Question

Write short notes on Insert Anomalies with example.

Answer 1

Insert Anomalies. An Insert Anomaly occurs when certain attributes cannot be inserted into the database without the presence of other attributes. For example this is the converse of delete anomaly - we can't add a new course unless we have at least one student enrolled on the course.