The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.
A) entity
B) referential
C) relational
D) null

Question

Quizplus · Accepted Answer

The given scenario highlights the entity integrity constraint as it ensures that the primary key column (CUS_CODE) in the CUSTOMER table has no null entries and all entries are unique. This constraint is applied to each entity (row) in the table. Relational integrity constraint (option C) applies to the relationship between tables, and referential integrity constraint (option B) ensures that data in a foreign key column matches the data in the primary key column of the related table. Null constraint (option D) refers to the requirement of having a value, or a set of values, in a column, and not allowing null entries.

The CUSTOMER Table's Primary Key Is CUS_CODE