In the context of total completeness,in a(n),every supertype occurrence is a member of only one subtype.
A)Foreign key constraint
B)nonunique constraint
C)overlapping constraint
D)disjoint constraint

Question

Quizplus · Accepted Answer

Total completeness means that every supertype occurrence must belong to at least one subtype. If subtypes overlap or if a subtype occurrence can belong to multiple subtypes, then the supertype occurrence may not belong to only one subtype. Therefore, the correct choice would be a disjoint constraint, where each supertype occurrence can belong to only one subtype.

In the Context of Total Completeness,in A(n),every Supertype Occurrence Is