Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 3 The following table records information about the schedule of presentations. Suppose the table has the following first normalization form: (FlightNo, FlightDate, FfoNo, AirportCode,
QUESTION 3 The following table records information about the schedule of presentations. Suppose the table has the following first normalization form: (FlightNo, FlightDate, FfoNo, AirportCode, AirportName, Gate, Airline, CustomerName, SeatNo, SeatClass), where (FlightNo, FlightDate, FfpNo) is the primary key of the table. If we have the following dependencies: (FlightNo, FlightDate) -> (AirportCode, AirportName, Gate) (FfpNo) -> (CustomerName) (FlightNo) -> (Airline) (AirportCode) -> (AirportName) (SeatNo) -> (SeatClass) Which of the following one IS NOT part of a second normalization form: (FlightNo, FlightDate, AirportCode, AirportName, Gate) O (FlightNo, Airline) O (FlightNo, FlightDate, FfpNo, Gate, SeatNo, SeatClass) (FfpNo, CustomerName)
Step 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