Integrity Constraints in DBMS

Integrity Constraints in DBMS are rules that ensure the accuracy, consistency, and reliability of data in a database. They prevent invalid data entry and maintain data integrity. The main types of integrity constraints in DBMS are:

1. Domain Constraint – Ensures that values in a column belong to a specific domain (e.g., age must be a positive integer).
2. Entity Integrity Constraint – Ensures that primary key values are unique and not NULL.
3. Referential Integrity Constraint – Ensures foreign keys in one table reference valid primary keys in another table, maintaining relationships.
4. Key Constraint – Ensures that every table has a unique primary key.
5. Check Constraint – Defines conditions that each row in a table must satisfy (e.g., salary > 0).

These integrity constraints in DBMS help maintain data correctness and prevent inconsistencies.