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?

i. What is the meaning of the arc in the diagram?

j. List the attributes inherited by the entity type RESV_AGENT.

k. List the attributes inherited by the entity type INDIVIDUAL.

l. List the attributes inherited by FIELD_STAFF.

m. Should all members of the GATE_STAFF also be members of FIELD_STAFF? If the answer is no, what modification must be made to EERD to enforce such a business rule?

n. List the attributes inherited by MUTUAL_FUND.

o. Which, if any, entity type(s) function as both a superclass and a category?

p. What is the identifier of the entity type MUTUAL_FUND?

q. Which entity type(s) require(s) the use of a surrogate key as an identifier?

r. Which entity types(s) function(s) as a superclass in one SC/sc relationship and as a subclass in another SC/sc relationship?

s. Is it possible for an individual stockholder to be an employee of the airline company? Explain your answer.

t. Suppose it is possible for an employee to own shares in a mutual fund that is an owner of the airline. Modify the ER diagram to incorporate this enhancement.

Taxi sno Name City State STOCKHOLDER PERSON Seating preference Size Job type Yrs experience PASSENGER MU INDIVIDUAL EMPLOYEE Hours flown Type Company name Crd rating Monthly salary GROUND STAFF FLIGHT STAFF BANK Pay scale fdsd# Total-deposits TECHNICIAN | | RESV-AGENT | | GATE-STAFF PILO FLIGHT ATTENDENT Shift Concourse ,License# Restriction. Domestic-vs-international-code Grade FIELD STAFF