In relational database terminology, what does referential integrity mean?
- Allows NULL values in a foreign key column
- Enforces unique constraints on multiple columns
- Ensures that foreign key values match the primary key values in another table
- Ensures that primary key values are unique
Referential integrity in a relational database means ensuring that foreign key values match the primary key values in another table. This prevents orphaned rows and maintains consistency in relationships between tables.
Loading...
Related Quiz
- In class-table inheritance, each subclass is represented by a _______ table.
- What is a common aggregation function used to calculate the average of a dataset?
- What are the characteristics of a dimension table in Dimensional Modeling?
- In an ERD, what is the purpose of an associative entity?
- How does Dimensional Modeling differ from Entity-Relationship Modeling?