Question

What is insertion anomaly in dbms

Answer 1

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. StudentNum. CourseNum

Answer 2

$\green{ \fcolorbox{grey}{grey}{ \checkmark \: \textsf{Verified \: answer}}}$

What is DBMS

• ⟹ DBMS software primarily functions as an interface between the end user and the database, simultaneously managing the data, the database engine, and the database schema in order to facilitate the organization and manipulation of data.

━━━━━━━━━━━━━━━━━━━━━━