Junior — Middle
What types of data integrity exist in database management systems?
sobes.tech AI
Answer from AI
In database management systems (DBMS), the main types of data integrity are:
- Entity Integrity — guarantees that each record in a table is unique and identified by a primary key that cannot be NULL.
- Referential Integrity — ensures the correctness of relationships between tables, e.g., a foreign key must reference an existing record or be NULL.
- Domain Integrity — restricts the values in columns to a specific data type, range, or set of allowed values.
- User-Defined Integrity — additional rules and constraints set by the user, such as triggers or checks.
These types of integrity help maintain data correctness and reliability in the database.