EER Diagram and modelling (link for picture https://ibb.co/2FX06vn)

In regards to the above diagram, answer the following questions using the multiple choice listed under each question. 

How is of_type modeled?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

How do you model Stored_in?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

In person, if address was a composite attribute, consisting of first name, last name, and middle initial, how would you model that attribute?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

In person, if phone was a multivalued attribute, allowing someone to list multiple phone numbers, how would you model that concept?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

How do you model Service?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

How do you model Plane-Type?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

How is Plane_service modeled?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation and n foreign keys
5. relation and foreign key with single attribute value
6. relation with owning entity primary key participating in primary key
7. one atomic attribute
8. relation and two foreign keys
9. set of simple component attributes

How is owner modeled?

1. The subclass & the super class are modeled into one relation
2. only the subclasses are modeled into a relation
3. none of the above
4. each participating subclass and superclass are modeled into a relation
5. only the superclass is modeled into a relation

Pilot and Employee are both subclasses? Are these subclasses related other than they both extended from the same superclass?

 

Model Capacity Weight M N WORKS ON PLANE_TYPE Reg# 1 OF_TYPE N AIRPLANE N Salary Shift EMPLOYEE MAINTAIN Restr Lic_num M M N FLIES PILOT Date Workcode Date/workcode N Pdate STORED_IN OWNS M N 1 HANGAR Number Location Figure 4.12 Capacity EER schema for a SMALL AIRPORT database. SERVICE Hours N PLANE_SERVICE OWNER U CORPORATION Ssn PERSON Name Phone Name Phone Address Address