VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l }
\text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \
111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \
222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \
333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \
444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }
\end{array}$$
-Functional dependency Type -- OwnerID exists in the table VEHICLE.

Question

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
 $$\begin{array} { l l l c l } 
\text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \
111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \
222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \
333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \
444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }
\end{array}$$
-Functional dependency Type --> OwnerID exists in the table VEHICLE.

Quizplus · Accepted Answer

The functional dependency Type --> OwnerID does not exist because the Type "Car" is associated with multiple OwnerIDs (O1 and O2), violating the rule that for a given Type, there should be a unique OwnerID.

VEHICLE Observe the Table VEHICLE That Contains the Following Four

VEHICLE
Observe the Table VEHICLE That Contains the Following Four