The Insertion Anomaly

• An Insertion Anomaly occurs when certain attributes cannot be inserted into the database without the presence of other attributes

We are running a rental cabin business and we add a new cabin, our database table is shown.

How do we enter a cabin before we have a booking

What if those fields were designated “Not-Null”