Technical Discussion :: DBMS
Home > Freshers > Technical Interview Questions > DBMS
54. 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.
Asked In :: iGate Virtusa Accenture Sopra Steria
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.
> 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.