Answered step by step
Verified Expert Solution
Link Copied!

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 -

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Guide To Client Server Databases

Authors: Joe Salemi

2nd Edition

1562763105, 978-1562763107

More Books

Students also viewed these Databases questions

Question

Discuss the order delivery stage of the order cycle.

Answered: 1 week ago

Question

b. Where did they come from?

Answered: 1 week ago

Question

c. What were the reasons for their move? Did they come voluntarily?

Answered: 1 week ago

Question

5. How do economic situations affect intergroup relations?

Answered: 1 week ago