Differentiate Total and Partial Completeness Constraints.
Answers
*•.¸♡ Here is your Answer ♡¸.•*
Total Completeness constraint:
Total Completeness constraint exist only if we have a super type and some subtypes associated with that supertype,
and the following situation exists between the super type and subtype. All the instances of the supertype entity must
be present in at one of the subtype entities, i.e.—there should be not instance of the supertype entity which does not
belong to any of the subtype entity.
Partial Completeness Constraint:
This type of completeness constraint exists when it is not necessary for any
supertype entity to have its entire instance set to be associated with any of the subtype entity. This type of situation
exists when we do not identify all subtype entities associated with a supertype entity, or ignore any subtype entity
due to less importance of least usage in a specific scenario.
Ehsass ♡
Answer:
★ Completeness constraint defines whether instances of the entity supertype should be the member of the at least one entity subtype.
★ Partial completeness specifies that all the instances of the entity supertype may not be the member of the entity subtype.