Question: 3. We are developing an ER model with three entities Flight, Airport and Attendant. There are two relationships between Flight and Airport, one is called

 3. We are developing an ER model with three entities Flight,

3. We are developing an ER model with three entities Flight, Airport and Attendant. There are two relationships between Flight and Airport, one is called "departs from" and another is called "arrives at Each flight departs from and arrives at exactly one airport. There is a complex relationship involving Flight, Airport, and Attendant. Each flight is assigned multiple attendants, each attendant may be assign to different flights, and the assignment is also with a specific airport for attendant to get on the flight at that airport. a. Draw the conceptual level ER diagram. b Derive a logical level ER design without any complex relationship. It also has no many-to-many relationships

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!