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}$$
-Deleting the following record in the table VEHICLE: 222,Car,Ford,O2,Pat
while leaving the remaining three records in the table,will cause an occurrence of a deletion 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}$$
-Deleting the following record in the table VEHICLE: 222,Car,Ford,O2,Pat
while leaving the remaining three records in the table,will cause an occurrence of a deletion anomaly.

Quizplus · Accepted Answer

A deletion anomaly occurs when deleting a record results in the loss of other valuable data. In this case, deleting the record for vehicle 222 will result in losing the information that Pat owns a Ford car, which is not stored elsewhere in the table.

VEHICLE Observe the Table VEHICLE That Contains the Following Four

VEHICLE
Observe the Table VEHICLE That Contains the Following Four