Data integrity

Definition:

Data integrity is an important set of rules in DBMS.
This rule prevents data loss from banning inappropriate editng, inserting and deleting actions.
There are 3 main types of data integrity:

• Entity integrity
• Referential integrity
• Domain integrity

---

Entity integrity

• This rule ensures that every records should exist at least one unique identifier(e.g. primary key).

---

Referential integrity

• This rule ensures that every foreign keys can be validate.

---

Domain integrity

• This rule ensures that every values can conform to the domain(e.g. data type,constraint) of the related attribute/field.

---

‘It is dangerous if losing data and jobs.’By secondary 6 student