Question

If a supertype entity called PRODUCT has attributes of Prod_Num, Prod_Title, Prod_ReleaseDate, Prod_Price, and Prod_type and a subtype entity called MOVIE has attributes of Prod_Num, Movie_Rating, Movie_Director, and a subtype entity called CD has attributes of Prod_Num, CD_Genre, and CD_Artist, what are considered the attributes of a movie?

a. Prod_Num, Movie_Rating, Movie_Director , CD_Genre, and CD_Artist
b. Prod_Num, Movie_Rating, Movie_Director
c. Prod_Num, Prod_Title, Prod_ReleaseDate, Prod_Price, Prod_type, Movie_Rating, Movie_Director
d. All of these attributes are listed in the question.

Answer 1

The correct option of the following question is c.) Prod_Num, Prod_Title, Prod_ReleaseDate, Prod_Price, Prod_type, Movie_Rating, Movie_Director.

Step-by-step explanation:

A supertype is the generic type entity that has relationship between one or more than one subtypes. The subtype is the sub-grouping of an entity in the entity type which is meaningful to an organization and shares are common attributes or the relationships are distinct from the other subgroups.

In other words, the supertype is the entity that has a relationship with one or more than one subtypes and it also contain the common attributes of subtypes.