Entity Integrity vs. Referential Integrity

Question 1

Distinguish between entity integrity and referential integrity in terms of a relational database.

Answer 1

Entity Integrity: Ensures each row has a unique identifier (primary key) and no null values in the primary key attributes.
Referential Integrity: Ensures relationships between tables are maintained, validating that foreign key values correspond to existing primary key values.
Flashcard Set B: Preventing Insertion in Terms of Integrity