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 OwnerID -- VehicleID 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 OwnerID --> VehicleID exists in the table VEHICLE.

Quizplus · Accepted Answer

The given functional dependency is OwnerID --> VehicleID, which means for each owner there can be multiple vehicles. However, in the given table there are cases where multiple owners have the same vehicle make and type, which violates the given functional dependency.

VEHICLE Observe the Table VEHICLE That Contains the Following Four

VEHICLE
Observe the Table VEHICLE That Contains the Following Four