Database 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.