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, 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
Get step-by-step solutions from verified subject matter experts
