CIW Exam Questions

Which situation would occur if new supplier information were entered in the relation before any info

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers.

Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

A.
An update anomaly and an insertion anomaly would occur.

B.
An insertion anomaly would occur.

C.
A deletion anomaly would occur.

D.
A deletion anomaly and an update anomaly would occur.