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