Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following instance of the Airport Database: name Airport Note: Each airport name is unique in its country. airportID city state country CDG Charles

image text in transcribed

Consider the following instance of the Airport Database: name Airport Note: Each airport name is unique in its country. airportID city state country CDG Charles de Gaulle Paris NULL FRA DXB Dubai International Dubai NULL UAE JFK John F Kennedy International New York NY USA LGA LaGuardia New York NY USA MIA Miami International FL USA SFO San Francisco International San Francisco CA USA Miami Carrier Note: Each carrier name is unique in the whole world. carrierID name fleetsize employees revenue AF Air France 225 84,602 15,414 DL Delta Air Lines 855 80,000 39,639 EK Emirates Airline 239 84,153 18,300 US 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 479 10/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 DU 1472 10/17/2017 7:30 AM LGA MIA 1,099 AR 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 Your answer List the candidate key(s) of the Carrier table (each in a separate line). 2 points Your answer List the candidate key(s) of the Carrier table (each in a separate line). 2 points Your answer 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

Informix Database Administrators Survival Guide

Authors: Joe Lumbley

1st Edition

0131243144, 978-0131243149

More Books

Students also viewed these Databases questions

Question

What is Working Capital ? Explain its types.

Answered: 1 week ago

Question

=+2 Why are so many countries bothered by their brain drains?

Answered: 1 week ago