Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Why does the following violate third normal form? (flight_number is the primary key) flight_number aircraft pilot_id pilot_rank 526 Boeing 747-400 137 Captain 628 Airbus A320
Why does the following violate third normal form? (flight_number is the primary key)
flight_number | aircraft | pilot_id | pilot_rank |
526 | Boeing 747-400 | 137 | Captain |
628 | Airbus A320 | 139 | Senior Captain |
321 | Airbus A320 | 137 | Captain |
Aircraft name is too long | ||
There is a transitive dependency from flight_number -> pilot_id -> pilot _rank | ||
Pilot_id 137 is not unique (it ised twice) | ||
Aircraft name contains both the manufacturer and the type number | ||
Pilot name is not provided |
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