Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

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_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Databases questions