database management question:

Complete the following tasks:

State two conditions that indicate when a database designer should consider using supertype/subtype relationships.

Give an example of such a relationship chosen from an application in your major (computer science).

What is the purpose of a subtype discriminator? Clearly identify the values (or some of the values if there are many) in your example.

Create the EER diagram for your example.