What is referential integrity in a database system?
- Enforces the use of indexes on all tables
- Ensures that foreign key values match the primary key values in another table
- Ensures that primary key values are unique
- Validates the data types of columns
Referential integrity in a database system ensures that foreign key values in one table match the primary key values in another table. This constraint maintains the consistency and accuracy of relationships between tables, preventing orphaned or invalid foreign key references.
Loading...
Related Quiz
- Version control in data modeling helps to ensure _______ of data models.
- What are the key differences between a superclass and a subtype in a Generalization and Specialization hierarchy?
- Which type of data does a dimension table primarily contain?
- The relationship between a department and an employee in a company database is typically _______.
- What is the result of applying aggregation functions to a dataset in a database?