Answered step by step
Verified Expert Solution
Link Copied!

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

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: 3

blur-text-image

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

The Temple Of Django Database Performance

Authors: Andrew Brookins

1st Edition

1734303700, 978-1734303704

More Books

Students also viewed these Databases questions

Question

Refer to the previous exercise. Provide the proper interpretation.

Answered: 1 week ago