Data Modeling - Data Integrity

1 - About

Data/Database integrity ensures that data entered into the database is:

Three basic types of database integrity constraints are:

  • Entity integrity, allowing no two rows to have the same identity within a table.
  • Domain integrity, restricting data to predefined data types, e.g.: dates.
  • Referential integrity, requiring the existence of a related row in another table, e.g. a customer for a given customer ID.

Any applicable integrity constraints and data validation rules must be satisfied before permitting a change to the database.

  • Bookmark "Data Modeling - Data Integrity" at del.icio.us
  • Bookmark "Data Modeling - Data Integrity" at Digg
  • Bookmark "Data Modeling - Data Integrity" at Ask
  • Bookmark "Data Modeling - Data Integrity" at Google
  • Bookmark "Data Modeling - Data Integrity" at StumbleUpon
  • Bookmark "Data Modeling - Data Integrity" at Technorati
  • Bookmark "Data Modeling - Data Integrity" at Live Bookmarks
  • Bookmark "Data Modeling - Data Integrity" at Yahoo! Myweb
  • Bookmark "Data Modeling - Data Integrity" at Facebook
  • Bookmark "Data Modeling - Data Integrity" at Yahoo! Bookmarks
  • Bookmark "Data Modeling - Data Integrity" at Twitter
  • Bookmark "Data Modeling - Data Integrity" at myAOL
data_modeling/integrity.txt ยท Last modified: 2016/11/16 11:07 by gerardnico