Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This the class for Database The following tables form an instance of an Airport Database held in a relational DBMS: Airport (airportID, name, city, state,
This the class for Database
The following tables form an instance of an Airport Database held in a relational DBMS: Airport (airportID, name, city, state, country) Carrier (carrierID, name, fleetSize, employees, revenue) Flight (carrier D, flightNo, date, time, airportID, destination, distance) Consider the following instance of the Airport Database: Airport Note: Each airport name is unique in its country. airportid name city state country CDG Charles de Gaulle Paris NULL FRA Dubai International Dubai NULL UAE JFK John F Kennedy International New York NY USA LGA LaGuardia New York NY USA MIA Miami International Miami FL USA SFO San Francisco International San Francisco CA USA DXB Carrier carrieri AF DL EK US Note: Each carrier name is unique in the whole world. name fleetSize employees revenue Air France 225 84,602 15,414 Delta Air Lines 855 80,000 39,639 Emirates Airline 239 84,153 18,300 US Airways 338 31,467 13,050 Flight Note: Any (carrierID, flightNo) combination is unique for the whole day. carrierid flightNo date time airportid destination distance DL 426) 10/16/2017 7:00 AM JFK SFO 2,586 DL 426 10/17/2017 7:00 AM JFK SFO 2,586 DL 47910/16/2017 7:25 PM JFK SFO 2,586 EK 721 10/17/2017 11:25 AM CDG DXB 3,259 US 783 10/17/2017 3:20 AM DXB JFK 6,843 DL 1472 10/17/2017 7:30 AM LGA MIA 1,099 AF 3577 10/17/2017 5:45 PM JFK CDG 3,629 US 3577 10/17/2017 9:40 AM LGA SFO 2,576 AF 3634 10/16/2017 1:20 PM CDG MIA 4,580 What is the cardinality of the Flight table? 1 point Your answer What is the degree of the Flight table? 1 point Your answer List the candidate key(s) of the Airport table (each in a separate line). 2 points List the candidate key(s) of the Carrier table (each in a separate line). 2 points List the foreign key(s) of the Flight table (each in a separate line). 2 points Your answer If airportID is the primary key of the Airport table, list the alternate key(s) of 1 point this table. Your answer What is the primary key of the Flight table? 2 points YourStep 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