What are the integrity rules in DBMS?

What are the integrity rules in DBMS?

Data integrity is one significant aspect while maintaining the database. So, data integrity is enforced in the database system by imposing a series of rules. Those set of integrity is known as the integrity rules.

There are two integrity rules in DBMS:

Entity Integrity : It specifies that “Primary key cannot have a NULL value.”

Referential Integrity: It specifies that “Foreign Key can be either a NULL value or should be the Primary Key value of other relation

Comments are closed.