Chapter 3 The Relational Data Model and Relational Database Constraint AIRPORT State FLIGHT Fight number Airtine Weekdays FLIGHT LEG number Arrival airport codeScheduled arrival time LEG INSTANCE number number Number of available seats Airplane_id Departure, time Arrival airport code Arrival ime FARE Flight number Fare code Amount Restrictions AIRPLANE TYPE Airplane _type name Max seats Company CAN LAND Airplane type name Airport code AIRPLANE Airplane idTotal number of seats Airplane.type SEAT RESERVATION Flight number Leg number Date Seat number Customer name Customer phone Figure 3.8 The AIRLINE relational database schema 3.1s Consider the following six relations for an order-processing database appli- cation in a company: CUSTOMER(Cust Crame, City) ORDERIOrder# Odate, Cust, Ord-amt) ORDERJTEMOrdert, terme aty)