ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c }
\text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \
111 & \text { Joe } & \text { El } & \text { Enghishl } \
222 & \text { Bob } & E 1 & \text { Enghishl } \
333 & \text { Lisa } & \text { H1 } & \text { Historyl }
\end{array}$$
-Which of the following actions in the table ENROLLMENT will be prevented by an insertion anomaly?
A)Entering a new student 444,Sue
B)Entering a new student 555,Lisa
C)Entering a new record 666,Bob,E1,English
D)Entering a new class M1,Math1

Question

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
 $$\begin{array} { c c c c } 
\text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \
111 & \text { Joe } & \text { El } & \text { Enghishl } \
222 & \text { Bob } & E 1 & \text { Enghishl } \
333 & \text { Lisa } & \text { H1 } & \text { Historyl }
\end{array}$$
-Which of the following actions in the table ENROLLMENT will be prevented by an insertion anomaly?
A)Entering a new student 444,Sue
B)Entering a new student 555,Lisa
C)Entering a new record 666,Bob,E1,English
D)Entering a new class M1,Math1

Quizplus · Accepted Answer

The table ENROLLMENT suffers from insertion anomaly because it is not possible to add a new class unless there is at least one student enrolled in it. Therefore, inserting a new class (M1, Math1) would be prevented by the insertion anomaly. Choices A, B, and C do not involve inserting a new class, so they would not be prevented by the insertion anomaly.

ENROLLMENT Observe the Table ENROLLMENT: ENROLLMENT -Which of the Following Actions in the Table ENROLLMENT Will

ENROLLMENT
Observe the Table ENROLLMENT:
ENROLLMENT -Which of the Following Actions in the Table ENROLLMENT Will