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 (regarding the relation ENROLLMENT)represents the deletion anomaly?
A)Deleting a student ID may delete a student name
B)Deleting a class ID may delete the class name
C)Deleting a class may delete all information about a student
D)Deleting a student may delete all information about a class

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 (regarding the relation ENROLLMENT)represents the deletion anomaly?
A)Deleting a student ID may delete a student name
B)Deleting a class ID may delete the class name
C)Deleting a class may delete all information about a student
D)Deleting a student may delete all information about a class

Quizplus · Accepted Answer

Deleting a student may delete all information about the class because the enrollment relation only records the connection between students and classes. Therefore, if a student is deleted, their enrollment in any classes will also be deleted, resulting in a loss of information about those classes.

ENROLLMENT Observe the Table ENROLLMENT: ENROLLMENT -Which of the Following (Regarding the Relation ENROLLMENT)represents the Deletion

ENROLLMENT
Observe the Table ENROLLMENT:
ENROLLMENT -Which of the Following (Regarding the Relation ENROLLMENT)represents the Deletion