In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype.
A) unique constraint
B) disjoint constraint
C) overlapping constraint
D) foreign key constraint

Question

Quizplus · Accepted Answer

In an overlapping constraint, every supertype occurrence is a member of at least one subtype. This ensures total completeness, as all occurrences of the supertype must be included in one of the subtypes. A unique constraint requires uniqueness in the values of one or more attributes, a disjoint constraint requires that a supertype occurrence belong to only one subtype, and a foreign key constraint establishes a relationship between two tables in a database. None of these directly address total completeness.

In the Context of Total Completeness, in A(n) _____, Every