Map this E-R Diagram to a Relational DBMS. Each table/relation represents one \"

Question

Map this E-R Diagram to a Relational DBMS.
Each table/relation represents one "entity type". The rows represent instances of that type of entity and the columns representing values attributed to that instance.

Name Schedded DepTme City S DEPARTURE AIRPORT AIRPORT FLIGHT LEG ARRIMAL AIRPORT LAND LEGS NSTANCE Weekdays Max-seats Number Compary FLIGHT AIRPLANE TYPE ARRVES FARES Oode FARE Date daal seats LEG INSTANCE AIRPLANE ASSIGNED CPhone NOTES (1ALEG (SEGMENT)ISANONSTOP PORTION OFAFLIGHT (2)ALEG INSTANCE ISAPARTICLLAROOCURRENCE RESERMATION OFALEG ON A PARTICULAR DATE SEAT

Explanation / Answer

If you have any doubts, please give me comment...

AIRPORT(Airport_code, Name, City, State);

FLIGHT(Flight_number, Airline, Weekdays);

FLIGHT_LEG(Flight_number, Leg_number, Departure_airport_code, Scheduled_departure_time, Arrival_airport_code, Scheduled_arrival_time);

LEG_INSTANCE(Flight_number, Leg_number, Date, Number_of_available_seats, Airplane_id, Departure_airport_code, Departure_time, Arrival_airport_code, Arrival_time);

FARE(Flight_number, Fare_code, Amount, Restictions);

AIRPLANE_TYPE(Airplace_type_name, Max_seats Company);

CAN_LAND(Airplace_type_name, Airport_code);

AIRPLANE(Airplane_id, Total_number_of_seats, Airplane_type);

SEAT_RESERVATION(Flight_number, Leg_number, Date, Seat_number, Customer_name, Customer_phone);

Note: Underline indicates Primary key of that relation

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---