Please answer these multiple choice questions.

How do you model Works_On?

1. Not modeled into any relationship
2. Relation with owning entity primary key participating in primary key
3. Set of simple component attributes
4. Foreign key (or "relationship relation")

 

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 two foreign keys

How is of_type modeled?

1. Not modeled into any relationship
2. relation
3. foreign key for "relationship" relation
4. relation with owning entity primary key participating in primary key
5. one atomic attribute
6. relation and two foreign keys

 

How is Plane_service modeled?

1. Not modeled into any relationship
2. relation and n foreign keys
3. relation and foreign key with single attribute value
4. relation with owning entity primary key participating in primary key
5. one atomic attribute

 

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 foreign key with single attribute value
5. set of simple component attributes
    

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