Which of the following is an example of an insertion anomaly?
A)A new student cannot be assigned to a professor because the student does not have a StudentID.
B)A department name must be changed manually in several records.
C)When professors retire, their records are removed from the database, which also loses information about the students they advised.
D)A student can take several classes, and classes can enroll many students.

Question

Quizplus · Accepted Answer

An insertion anomaly occurs when certain information cannot be inserted into the database without the presence of other information. In choice A, a new student cannot be assigned to a professor because the student does not have a StudentID, which is a classic example of an insertion anomaly. This is because the database requires a StudentID to create a new record, and without it, the student's information, including their assignment to a professor, cannot be inserted into the database.

Which of the Following Is an Example of an Insertion