Referential Integrity

Referential Integrity: The referential integrity constraint is specified between two relations and is used to maintain the consistency among tuples of two relations of same data file in the same organization. Referential integrity states that if a foreign key exist in a relation, then the foreign key value must match the primary key value of some tuple in its home relation or the foreign key value must be completely null.

Data Integrity

Data Integrity Data Integrity: Data integrity refers to the correctness and consistency of data. It is another form of database protection or security, security involves protecting the data from unauthorized…

Continue Reading Data Integrity