Define The "integrity Rules"?

1.	Define The "integrity Rules"?
Answer» There are two Integrity rules. Entity Integrity: States that "PRIMARY KEY cannot have NULL value". REFERENTIAL Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other RELATION. There are two Integrity rules. Entity Integrity: States that "Primary key cannot have NULL value". Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.

Answer»

There are two Integrity rules.

Entity Integrity: States that "PRIMARY KEY cannot have NULL value".

REFERENTIAL Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other RELATION.

There are two Integrity rules.

Entity Integrity: States that "Primary key cannot have NULL value".

Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.

Discussion