Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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 JohnStep 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