Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started