91.2k views
4 votes
Describe in your own words the two main data integrity constraints that we learnt in our discussion of databases. Provide your own examples of their use.

User Girardengo
by
5.1k points

1 Answer

5 votes

Answer:

Domain integrity constraint and Entity integrity constraint

Step-by-step explanation:

Data integrity constraints protect the quality of data by ensuring data doesn't lose its integrity, validity, or consistency when there is update to data. Data integrity constraints are rules applied to table columns in DBMS systems to prevent any unintentional damage to data. There are four types of data integrity constraints: domain integrity constraint, entity integrity constraint, referential integrity constraint, and key constraint.

Domain integrity constraint applies rules to protect against the values or attributes in the table column.

Entity integrity constraint applies rules to protect the uniqueness of rows in the table.

User Liam Kernighan
by
5.0k points