Question

What is an entity supertype, and why is it used?

A) An entity supertype is a generic entity type that is related to one or more entity subtypes, where the entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
B) The reason for using supertypes is to minimize the number of nulls and to minimize the likelihood of redundant relationships.

Answer 1

Correct answer is option B (The reason for using supertypes is to minimize the number of nulls and to minimize the likelihood of redundant relationships)

Step-by-step explanation:

Entity supertype

A entity supertype is a generic entity type which is related with one or more subtypes.

Use of entity supertype:

The reason for using entity supertype is to reduce redundant relationships and it is also used to minimize the number of nulls.