Consider the following Presentation Layer ER diagram. a. Identify all entity types that at one time or

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 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?
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Modeling and Database Design

ISBN: 978-1285085258

2nd edition

Authors: Narayan S. Umanath, Richard W. Scammel

Question Posted: