Reference no: EM132637966
Ticket Reservations Sales LLC Company provides services to the commercial airlines from its data center.
IT System main parameters are ; The data center and company offices are in the same building . Processing 500,000 Tickets a day. It has 150 employees.
There are two databases.
Ticket Sales database to keep track of
The ticket number
Date of sale
Airline Name
Paid amount (price of the ticket)
Who sold the ticket (employee info )
HR Employee database to keep track of
Employee ID Number
Employee name
Position/ title
Pay scale (salary)
All member airlines were connected to the Ticket Sales database in the Headquarters via the Internet (Web-Based Data Base ). Only people within the company can access to the HR Employee database.
Consider the given case and answer the following question
1. There are two databases,
Indicate the primary key for each database
Design codes for all data sections (field/attribute) in both databases
2. For the Database management system (DBMS);
List the DBMS Components for each database
Draw the Entity-Relationship Diagrams diagram to show the One-to-one relationship between given to database.
|
Essentials intuitive user interface makes
: Essentials' intuitive user interface makes it easy for researchers to search and find in-depth information on businesses, industries and products.
|
|
What is the firm operating cash flow for tubby toys
: Sales of $7 million, operating costs of $4 million, and a depreciation expense of $1 million. If the tax rate is 25%, what is the firm's operating cash flow?
|
|
Analyze the psychological motivations of the founding father
: In 500-750 words, analyze the psychological motivations of the founding fathers in the creation of the Bill of Rights. Specifically, focus on one of the.
|
|
Is a reasonable procedure for purposes of calculating npv
: Can you suggest a better way to assess a cost of the office space used by the project? Is this a reasonable procedure for purposes of calculating NPV?
|
|
Company provides services to commercial airlines
: Ticket Reservations Sales LLC Company provides services to the commercial airlines from its data center.
|
|
How much will the irs assess in taxes and penalties
: How much will the IRS assess in taxes and penalties in this matter and from whom? How can you, as a tax professional, best offer service to Madison, Martin.
|
|
Which are incremental cash flow associated with the donation
: A corporation donates a valuable painting from its private collection to an art museum. Which are incremental cash flows associated with the donation
|
|
How did access to information impact the way you perceived
: How did access to information, physiological influences, psychological influences, and social influences impact the way you perceived a recent significant.
|
|
Data customer collection and information management
: Research and assess the ethical issues related to data customer collection and information management. How will customer information be protected?
|