Question: Consider the following Presentation Layer ER diagram. a. Identify all entity types that at one time or another function as a superclass. b. List the
a. Identify all entity types that at one time or another function as a superclass.
b. List the superclass entity type and subclass entity type(s) in each distinct specialization.
c. Identify an entity type that functions as a shared subclass? What type of specialization does this entity type reflect?
d. Which entity types comprise the entire specialization hierarchy? For each level in this specialization hierarchy, define which entity types serve as a superclass and which serve as a subclass?
e. Which entity type functions as a superclass in more than one specialization?
f. How many Superclass/subclass (SC/sc) relationships appear in the ER diagram?
g. How many specializations appear in the ER diagram?
h. Which entity types in the diagram form a category?
Step by Step Solution
3.48 Rating (164 Votes )
There are 3 Steps involved in it
a PERSON EMPLOYEE GROUNDSTAFF FLIGHTSTAFF RESVAGENT GATESTAFF FLIGHTATTENDANT BANK INDIVIDUAL MUTUALFUND these are superclasses in the STOCKHOLDER categorization b Superclass PERSON Subclasses INDIVID... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
887-CS-DB (2129).docx
120 KBs Word File
