Answered step by step
Verified Expert Solution
Question
1 Approved Answer
his ER diagram will be used for the following questions citing SUNSHINE AIRLINE ER Diagram. In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which
his ER diagram will be used for the following questions citing SUNSHINE AIRLINE ER Diagram.
In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace BBB
SUNSHINE AIRLINE COMPANY
The ER Diagram for the SUNSHINE AIRLINE COMPANY is based on the following:
For each airplane type, we keep track of a unique airplane type ID AirplaneTypeID number of engines NoOfEngines and number of seats NoOfSeats
For each airport, we keep track of a unique airport ID AirportID and the length of the main runway LengthOfRunway
Each airplane type is able to land at one airport at least, but may be able to land at many airports. Each airport accommodates landing of at least one airplane type, but may accommodate landing of more airplane types.
Sunshine airline.jpg
This ER diagram will be used for the following questions citing SUNSHINE AIRLINE ER Diagram.
In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace BBB
AIRPORT
AirplaneTypeID
AIRPLANETYPE
AirportID
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started