Database integrity

From Wikipedia, the free encyclopedia

You have new messages (last change).

This article or section is in need of attention from an expert on the subject.
WikiProject Computer science or the Computer science Portal may be able to help recruit one.
If a more appropriate WikiProject or portal exists, please adjust this template accordingly.

This article may require cleanup to meet Wikipedia's quality standards.
Please discuss this issue on the talk page or replace this tag with a more specific message.
This article has been tagged since June 2006.

Database Integrity is to ensure that data entered in the database is accurate and valid. This means that if there is any rule applied to any entity, the entered data must obey that rule.

Entity integrity allows no two rows with the same identity in a table.

Domain integrity allows only predefined values, e.g.: dates.

Referential integrity allows only the consistency of values across related tables, e.g.: only IDs of registered customers

User-defined integrity allows only what you predefine

 This database software-related article is a stub. You can help Wikipedia by expanding it.
Retrieved from "http://en.wikipedia.org../../../d/a/t/Database_integrity.html"
In other languages