Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Convert the ER Diagram for an AIRLINE database below to IE (Crow's Feet) notation. When you have your ERD in IE notation, you need to
Convert the ER Diagram for an AIRLINE database below to IE (Crow's Feet) notation. When you have your ERD in IE notation, you need to show foreign key migration as well as an intersection entity for a many-to-many (M:N) relationship. Please use familiar software like MS Visio or Visual Paradigm
) (State) (Name Airport code City DEPARTURE AIRPORTN Leg-no AIRPORT Scheduled_dep_time Scheduled arrtime FLIGHT_LEG 1ARRIVAL AIRPORT CAN LAND Instances LEGS Number Type name Max seats INSTANCE_OF Airline FLIGHT Company AIRPLANE TYPE Arrtime Weekdays DEPARTS1 FARES Restrictions Amount Code ARRIVES Dep time TYPE FARE Airplane-id (Total-no-of-seats o of avail seats Date AIRPLANE ASSIGNED LEG INSTANCE Customer name Cphone Seat no RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight. A LEG INSTANCE is a particular occurrence SEAT of a LEG on a particular date
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