Database Relational Integrity

RELATIONAL INTEGRITY:

Rules that ensures that data is accurate.

1. Entity Integrity: no nll in pkey ( Null: no value in a key even not space. )
2. Referential Integrity J (of reference) if a foreign key exists in a relation,
3. either the foreign key value must match a candidate key value of some tuple in it’s
4. home relation or the foreign key value must be wholly null.
5. Enterprise Constraints: enterprise =organisation ..additional rules specified by the
6.  users or db admin of a db.