How to Translate the following ER-diagram into relational schema? Cuport Cay Sta

Question

How to Translate the following ER-diagram into relational schema?

Cuport Cay State Name DEPARTURE AIRPORT N FLIGHT LEG ARRIVAL N CAN AIRPORT Instances LEGS LAND Number INSTANCE OF lype name Max seats FLIGHT Airline Company AIRPLANE Arr time Weekdays TYPE DEPARTS FARES Restrictions N ARRIVES TYPE FARE Airplane id Total no of seats o of avai seats Date AIRPLANE ASSIGNED LEG INSTANCE Cphone RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight. SEAT A LEG INSTANCE is a particular occurrence of a LEG on a particular date Figure 3.21 An ER diagram for an AIRLINE database schema.

Explanation / Answer

Relational Schema

Tables and their attributes

Strong entities to tables

Primary keys ---- underlined , foreign keys ----- italicized

Weak entities to tables --- Make composite (primary key of strong entity+ primary key of weak entity) and make primary key of strong entity foreign key also.

Relationship sets to tables --- take primary keys of both entities having this relationship and make the primary keys foreign keys also to the two tables.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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