EER Diagram and modelling (link for picture https://ibb.co/2FX06vn) In regards to the above diagram, answer the following
Question:
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?
- 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?
Research Methods For Business Students
ISBN: 9781292208787
8th Edition
Authors: Mark Saunders, Philip Lewis, Adrian Thornhill