Interpret Figure airline ER schema. An ER diagram for an AIRLINE database schema

Question

Interpret Figure airline ER schema.

An ER diagram for an AIRLINE database schema. Airport Code City State (Name DEPARTURE AIRPORT N Leg no AIRPORT Scheduled dep time Scheduled arr time FLIGHT LEG 1 ARRIVAL CAN Instances LEGS AIRPORT LAND Number INSTANCE OF Type name Max seats FLIGHT Airline Company AIRPLANE Arr time Weekdays TYPE DEPARTS 1 FARES Restrictions ARRIVES Dep time Amount TYPE Code FARE Airplane id No of avail Seats Total no of seats Date AIRPLANE 1 ASSIGNED LEG INSTANCE Cphone Customer name Seat no RESERVATION So Notes: A LEG (segment) is a nonstop portion of a flight. SEAT A LEG UNSTANCE is a particular occurrence of a LEG on a particular date.

Explanation / Answer

When ER model converted into diagrams it gives a full entity relationship.

We can map ER diagrams into relational schema.

We cannot take all data which is available in ER diagram instead of that, it is required which is taken form ER diagram and approximate relational schema can be generated.

TO convert ER into relational model following steps are required

The ER model for the above question given below.

AIRPORT(Airport_code,city,state,name);

Here Airport_code is the primary key for the table AIRPORT.

AIRPLANE_TYPE(company,type_name,max_seats)

Airplane_ id is the foriegn key to AIRPLANE_TYPE.

RESERVATION(customername,cphone)

SEAT(seat_no)

seat_no has forign key relation to RESERVATION table.

FARE(code,amount,restrictions,,agegroup)

Here code primary key for the table FARE.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.