question archive Ticket Reservations Sales LLC Company provides services to the commercial airlines from its data center

Ticket Reservations Sales LLC Company provides services to the commercial airlines from its data center

Subject:Computer SciencePrice: Bought3

Ticket Reservations Sales LLC Company provides services to the commercial airlines from its data center.

Ticket Reservations Sales LLC 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 HR Employee database.

Consider the given case and answer the following question

Q1) There are two databases,

Indicate the primary key for each database

Design codes for all data sections (field/attribute) in both databases

Q2) 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

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE