Which of the Following Is an Example of an Insertion

Multiple Choice

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.