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}$$
-Attempting to insert a new owner O4,Matt in the table VEHICLE will cause an occurrence of an insertion anomaly.

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}$$
-Attempting to insert a new owner O4,Matt in the table VEHICLE will cause an occurrence of an insertion anomaly.

Quizplus · Accepted Answer

Since Matt does not currently own any vehicle, inserting a new record for him in the Vehicle table will result in a duplication of Ford and Honda Make records, which can lead to data inconsistency. This is an example of an insertion anomaly.

VEHICLE Observe the Table VEHICLE That Contains the Following Four

VEHICLE
Observe the Table VEHICLE That Contains the Following Four