Practice mode DBMS and SQL

Which integrity rule states that no attribute of a primary key may contain NULL?

Correct answer C. Entity integrity

Explanation

Entity integrity requires every primary key value to be present and unique, because the key is how each tuple (entity) is identified; a NULL would mean an unidentifiable row. SQL enforces this by making PRIMARY KEY imply NOT NULL and UNIQUE. Referential integrity is the separate rule that a foreign key value must match an existing primary key value or be NULL.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.