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

Answer 1

Relational Schema:

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

Here is the link that how we construct ER to Relational schema...

http://users.cms.caltech.edu/~donnie/dbcourse/intro0607/lectures/Lecture17.pdf

Let me know if you have any clarifications. Thank you...