Question: what is the difference between partial and total completeness. illustrate with examples?
Answer: a. Partial completeness - Specifies that an entity instance of the supertype is allowed not to belong to any subtype. ... Total completeness - Specifies that each entity instance of the supertype must be a member of some subtype in the relationship.