PrepAway - Latest Free Exam Questions & Answers

What database concept has been violated?

A database contains an entry with an empty primary key. What database concept has been violated?

PrepAway - Latest Free Exam Questions & Answers

A.
Entity Integrity

B.
Normalization

C.
Referential Integrity

D.
Semantic Integrity

Explanation:
Answer A is correct; Entity integrity means each tuple has a unique primary key that is not null.

Incorrect Answers and Explanations: B, C, and D: Answers B, C, and D are incorrect. Normalization seeks to make the data in a database table logically concise, organized and consistent. Referential integrity means that every foreign key in a secondary table matches a primary key in the parent table: if this is not true, referential integrity has been broken. Semantic integrity means each attribute (column) value is consistent with the attribute data type.

One Comment on “What database concept has been violated?


Leave a Reply