Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Contemporary Issues In Database Design And Information Systems Development

Authors: Keng Siau

1st Edition

1599042894, 978-1599042893

More Books

Students also viewed these Databases questions

Question

1. How does Kiwi Experience maintain a continual customer focus?

Answered: 1 week ago