Question: Please answer clearly. A thumbs up for the right solution :D For your reference, data requirements and constraint specification associated with the ERD are -

 Please answer clearly. A thumbs up for the right solution :D

Please answer clearly. A thumbs up for the right solution :D

For your reference, data requirements and constraint specification associated with the ERD are - The database represents each AIRPORT, keeping its unique AirportCode, the AIRPORT Name, and the Each airline FLIGHT has a unique number, the Airline for the FLIGHT, and the Weekdays on which the .A FLIGHT is composed of one or more FLIGHT LEGs (for example, flight number CO1223 from New City and State in which the AIRPORT is located. FLIGHT is scheduled (for example, every day of the week except Sunday can be coded as X7) York to Los Angeles may have two FLIGHT LEGs: leg 1 from New York to Houston and leg 2 from Houston to Los Angeles). Each FLIGHT LEG has a DEPARTURE AIRPORT and Scheduled Departure Time, and an ARRIVAL AIRPORT and Scheduled Arrival Time. -A LEG INSTANCE is an instance of a FLIGHT LEG on a specific Date (for example, CO1223 leg 1 on July 30, 1989). The actual Departure and Arrival AIRPORTs and Times are recorded for each flight leg after the flight leg has been concluded. The Number of available seats and the AIRPLANE used in the LEG INSTANCE are also kept. The customer RESERVATIONs on each LEG INSTANCE include the Customer Name, Phone, and Seat Number(s) for each reservation. . Information on AIRPLANEs and AIRPLANE TYPEs are also kept. For each AIRPLANE TYPE (for example, DC-10), the TypeName, manufacturing Company, and Maximum Number of Seats are kept. The AIRPORTs in which planes of this type CAN LAND are kept in the database. For each AIRPLANE, the Airplaneld, Total number of seats, and TYPE are kept. 1. Draw a set of relational schema for each question below 1-1. (1:N Relationship) Show a set of relations for a part of the ER-diagram below. 1-2. (N:M Relationship) Show a set of relations for a part of the ER-diagram below City State CName 1-3. (Weak Entity and Identified Relationship) Show a set of relations for a part of the ER-diagram below City) State Name AIRPORTN dep FIGHT ARAVAL FLIGHT

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Solution for Question ID 9934465 Below is the correct relational schema for each part based on the p... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!