Map the BANK ER schema of Exercise 3 23 (shown in Figure 3 21) into a relational schema Specify all primary keys and foreign keys Previous Next Airport code City State Name DEPARTURE AIRPORT Leg no AIRPORT Scheduled dep time Scheduled arr time FLIGHT LEG W ARRIVAL ARRIVAL AIRPORT Instances Restrictions Dep time) N NY ARRIVES TYPE Amount Code FARE Airplane id Total no of seats No of avail seats Date AIRPLANE VASSIGNED A Customer name Cphone LEG INSTANCE Seat no SEATYN Notes A LEG (segment) is a nonstop portion of a flight 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

Question

Map the BANK ER schema of Exercise 3 23 (shown in Figure 3 21) into a relational schema  Specify all primary keys and foreign keys  Previous Next Airport code City State Name DEPARTURE AIRPORT Leg no AIRPORT Scheduled dep time Scheduled arr time FLIGHT LEG W ARRIVAL ARRIVAL AIRPORT Instances   Restrictions Dep time) N NY   ARRIVES     TYPE Amount Code FARE Airplane id Total no of seats No of avail seats Date AIRPLANE VASSIGNED A Customer name Cphone LEG INSTANCE Seat no   SEATYN Notes  A LEG (segment) is a nonstop portion of a flight  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

Accepted Answer

The Answer is in the image, click to view ...

Question

Map the BANK ER schema of Exercise 3.23 (shown in Figure 3.21) into a relational schema. Specify all primary keys and foreign keys. Previous Next

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Database Machine Performance Modeling Methodologies And Evaluation Strategies Lncs 257

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question