Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Database discussion

Database discussion

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

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Topnotch Essay only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided byTopnotch Essay are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Topnotch Essay is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Topnotch Essay, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.