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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

Your Enterprise Is Creating a Relation (Shown in the Exhibit)