What is integrity?

Learn the concept of data consistency.

Data integrity keeps data correct and consistent. It prevents invalid entries.

-- Entity: PRIMARY KEY
-- Referential: FOREIGN KEY
-- Domain: CHECK + NOT NULL

Three integrity types.

What is integrity? — details

If integrity breaks, data becomes inconsistent. JOINs give wrong results, reports mislead.

For example, if orders of a deleted customer remain, reports show sales with no owner; constraints prevent such inconsistencies up front.

Add a CHECK on balance in accounts: no negative values.

Show example solution

ALTER TABLE accounts
ADD CHECK (balance >= 0)

Integrity

Data ____ keeps data consistent

Show answer

Data integrity keeps data consistent