skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

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

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®

Back To Top