Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

) (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

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

Students also viewed these Databases questions

Question

4. Describe the role of narratives in constructing history.

Answered: 1 week ago

Question

1. Identify six different types of history.

Answered: 1 week ago