How Many Integrity Rules Are There And What Are They?

1.	How Many Integrity Rules Are There And What Are They?
Answer» There are Three Integrity Rules. They are as follows :: ENTITY Integrity Rule :: The Entity Integrity Rule enforces that the Primary key cannot be Null Foreign Key Integrity Rule :: The FKIR denotes that the relationship between the foreign key and the primary key has to be enforced.When there is data in Child TABLES the MASTER tables cannot be deleted. Business Integrity Rules :: The Third Intigrity rule is about the complex business processes which cannot be IMPLEMENTED by the above 2 rules. There are Three Integrity Rules. They are as follows ::

Answer»

There are Three Integrity Rules. They are as follows ::

ENTITY Integrity Rule :: The Entity Integrity Rule enforces that the Primary key cannot be Null
Foreign Key Integrity Rule :: The FKIR denotes that the relationship between the foreign key and the primary key has to be enforced.When there is data in Child TABLES the MASTER tables cannot be deleted.
Business Integrity Rules :: The Third Intigrity rule is about the complex business processes which cannot be IMPLEMENTED by the above 2 rules.

There are Three Integrity Rules. They are as follows ::

Discussion