Answered step by step
Verified Expert Solution
Link Copied!

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 Databaseimage text in transcribedimage text in transcribedimage text in transcribed

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 Your

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

Database Systems Introduction To Databases And Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st Edition

1943153191, 978-1943153190

More Books

Students also viewed these Databases questions

Question

Discuss the effectiveness of a national infrastructure for HRD

Answered: 1 week ago

Question

what are the four benefits of recycling waste production?

Answered: 1 week ago