Regards to the diagram below (figure 4.12), answer the following questions using the multiple-choice listed under each question. How is of_type modeled? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes How do you model Stored_in? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys 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? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys 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? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes How do you model Service? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes How do you model Plane-Type? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes How is Plane_service modeled? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes How is owner modeled? The subclass & the super class are modeled into one relation only the subclasses are modeled into a relation none of the above each participating subclass and superclass are modeled into a relation 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? Yes No
Regards to the diagram below (figure 4.12), answer the following questions using the multiple-choice listed under each question.
How is of_type modeled?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- set of simple component attributes
How do you model Stored_in?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- 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?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- 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?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- set of simple component attributes
How do you model Service?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- set of simple component attributes
How do you model Plane-Type?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- set of simple component attributes
How is Plane_service modeled?
- Not modeled into any relationship
- relation
- foreign key for "relationship" relation
- relation and n foreign keys
- relation and foreign key with single attribute value
- relation with owning entity primary key participating in primary key
- one atomic attribute
- relation and two foreign keys
- set of simple component attributes
How is owner modeled?
- The subclass & the super class are modeled into one relation
- only the subclasses are modeled into a relation
- none of the above
- each participating subclass and superclass are modeled into a relation
- 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?
- Yes
- No
Trending now
This is a popular solution!
Step by step
Solved in 2 steps