Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ChinaTravel Agents (CTA) wants a database to keep information about its many offices and the people involved in its operations, and about airline companies and

ChinaTravel Agents (CTA) wants a database to keep information about its many offices and the people involved in its operations, and about airline companies and the flights they offer. Every office has a unique number and an address. For each person, we need to store the name, the address, one home phone number, and a unique ID number. If the person is an CTA employee we also need to store his/her EID and business phone number, as well as the office he/she works for. Some CTA employees are managers. For each manager it is required to know their qualifications, their annual salary, and the set of offices under their management. Note that, for agents (=CTA employees who are not managers), we store their hourly pay rate. A person can book a flight via an agent (who is not a manager). For each flight we need the following information: flight number, airport code, date of departure, and destination. Flight numbers are unique only within the same airline. When a flight is booked we need to know the date of booking and the price. Each airline company offers a set of flights, and has a unique code, a name, and a list of phone numbers with a description for each phone number. Design an (Enhanced) Entity Relationship diagram according to the above requirements. Make sure to indicate constraints.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Programming The Perl DBI Database Programming With Perl

Authors: Tim Bunce, Alligator Descartes

1st Edition

1565926994, 978-1565926998

More Books

Students also viewed these Databases questions

Question

=+What is the most that you should pay to complete development?

Answered: 1 week ago

Question

=+development and make the product, should you go ahead and do so?

Answered: 1 week ago