Disclaims:

Always study and research the information here first before use! UAYOR!

Codd's Rules No 10: Data Integrity Is a Function of the DBMS

  • In order to be considered relational, data integrity must be an internal function of the DBMS; not the application program
  • Data integrity means the consistency and accuracy of the data in the database (i.e., keeping the garbage out of the database)
  • Data integrity got 3 type:
  1. entity,
  2. domain, and
  3. referential
  • Within the database, data integrity can be enforced procedurally or declaratively
  1. Declarative data integrity involves placing or 'declaring' constraints on column
  2. Procedural data integrity is maintained through code (i.e., through stored procedures or triggers)

0 comments:

  © Blogger template 'A Click Apart' by Ourblogtemplates.com 2008

Back to TOP