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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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?

  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?

  1. Yes
  2. No
Salary
Shift
Model Capacity Weight
M.
WORKS_ON
N
EMPLOYEE
N
ΜΑIΝΤΑΙN
PLANE_TYPE
Restr
Lic_num
M
1
N
FLIES
PILOT
OF TYPE
Date
Workcode
N
Date/workcode
SERVICE
Hours
Reg#
AIRPLANE
PLANE_SERVICE
N
Pdate
STORED_IN
OWNS
OWNER
M
HANGAR
CORPORATION
Ssn
PERSON
Number
Location
Name
Phone
Name
Phone
Сараcity
Address
Address
Figure 4.12
EER schema for a SMALL_AIRPORT database.
Transcribed Image Text:Salary Shift Model Capacity Weight M. WORKS_ON N EMPLOYEE N ΜΑIΝΤΑΙN PLANE_TYPE Restr Lic_num M 1 N FLIES PILOT OF TYPE Date Workcode N Date/workcode SERVICE Hours Reg# AIRPLANE PLANE_SERVICE N Pdate STORED_IN OWNS OWNER M HANGAR CORPORATION Ssn PERSON Number Location Name Phone Name Phone Сараcity Address Address Figure 4.12 EER schema for a SMALL_AIRPORT database.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY