Differentiate Total and Partial Completeness Constraints-01235
This subjective question is related to the book/course
vu eng101 English Comprehension.
It can also be found in
vu eng101 Mid Term Solved Past Paper No. 2.
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.
(Page 103)
