Question - What integrity rules exist in the DBMS?
Answer -
There are 2 major integrity rules that exist in the DBMS.
They are:
- Entity Integrity: This states a very important rule that value of a Primary key can never have a NULL value.
- Referential Integrity: This rule is related to the Foreign key which states that either the value of a Foreign key is a NULL value or it should be the primary key of any other relation.