GITTA-Logo
PDF Version of this document Search Help Glossary

Lesson Navigation IconRelational database model

Unit Navigation IconConcepts

Unit Navigation IconTransforming ER-schema

Unit Navigation IconData integrity

LO Navigation IconKey integrity

LO Navigation IconEntity integrity

LO Navigation IconReferntial integrity

LO Navigation IconIntegrity endangering

Unit Navigation IconNormalization

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconGlossary

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Entity integrity

The entity integrity is a result of the key integrity: No primary key is allowed to be the NULL(=no value). If NULL-values would be allowed for primary keys, than two tuples could have NULL as key value and therefore could not be distinguishably anymore. The key integrity would not be respected. In SQL special routines (unique, not null) are used for key and entity integrity.

Example:

ID Name Surname Year
NULL Miller John 1955
NULL Miller John 1985


Since the primary key (here ID) of both tuples is NULL, we are not able to distinct these tuples.

Top Go to previous page Go to next page