Question: a. List all function dependencies. b. Identify all composite determinants c. List all unique determinants d. List all candidate keys e. Identify the primary key

 a. List all function dependencies. b. Identify all composite determinants c.

a. List all function dependencies.

b. Identify all composite determinants

c. List all unique determinants

d. List all candidate keys

e. Identify the primary key

FlightDate FlightNumber AirlineName, AircraftNumber United United CitvFrom NumberofSeats PassengerNumber PassengerName 1000 1001 1002 2000 2001 1000 1000 1001 2001 1000 1000 CityTo Los 10/12/2016 Angeles New York Los 10/12/2016 Angeles New York UA101 A12 UA12 UA12 UA12 UA12 UA12 SQ1 SQ1 SQ1 UA12 UA13 John UA101 Los 10/12/2016 Angeles New York 10/12/2016 New YorkAngeles 10/12/2016 New York Angeles 10/12/2016 New York Angeles 10/13/2016 PhoenixDetroit 10/13/2016 PhoenixDetroit UA101 UA102 UA102 United Los United Jane Los United Los UA102 SW101 SW101 SW101 UA101 United Southwest Southwest Southwest United 122 122 122 John Sue Sally Lo 10/12/2016 Phoenix Detroit Los 10/13/2016 Angeles New York John Los UA103 United 11/12/2016 Tokyo Angeles 450 John

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!