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 modification anomaly?
A)If a class name changes,it may have to be changed in more than one record
B)If a student ID changes,we may have to change the class ID as well
C)If a class ID changes,we may have to change the student ID as well
D)If a student decides to use a longer version of his or her name,we cannot accommodate that modification

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 modification anomaly?
A)If a class name changes,it may have to be changed in more than one record
B)If a student ID changes,we may have to change the class ID as well
C)If a class ID changes,we may have to change the student ID as well
D)If a student decides to use a longer version of his or her name,we cannot accommodate that modification

Quizplus · Accepted Answer

The modification anomaly occurs when a change in one attribute value leads to the necessity of modifying other attribute values that are not logically related. In this case, if the class name changes, it will have to be changed in more than one record, which is an example of a modification anomaly. The other options are not indicative of modification anomalies.

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

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