An example of a transitive dependency in a database is:
A)Student ? grade
B)Telephone area code ? phone number
C)Airline ? flight number
D)Parking Code ? parking fine amount

Question

An example of a transitive dependency in a database is:
A)Student ?  grade
B)Telephone area code ?  phone number
C)Airline ?  flight number
D)Parking Code ?  parking fine amount

Quizplus · Accepted Answer

A transitive dependency in a database occurs when one non-prime attribute is functionally dependent on another non-prime attribute, which is itself functionally dependent on the primary key. In option D, "Parking Code" could be the primary key, and "parking fine amount" is a non-prime attribute that does not directly depend on the primary key but rather on another non-prime attribute (e.g., the type of parking violation, which depends on the parking code). This creates a transitive dependency: Parking Code -> Type of Parking Violation -> Parking Fine Amount.

An Example of a Transitive Dependency in a Database Is