NINO DOB Address Tel Religion Name Name (1.3) (1.1) Patient H Next of Kin Nuraina Hame Na (1,1) (1.n) has GP Name (1,11 Day Care Resident Address Weekidays 11,1) (1n) Social Worker Teino BaseLine Allocated Addre Cellection is Time Arrival Pulse Time

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
Which of the following statements are true in the nursing home conceptual design  as depicted by the EER diagram of the document above: Group of answer choices 1. Day Care and Resident have been conceptualised as disjoint Subclass Entity Sets of a more general class Patient 2. All entities known as Resident appear to have a specific relationship not applicable to Day Care entities 3. All entities known to the database as Patient must be classified either as Day Care or as Resident, or both. 4. All entities known to the database as Patient must be classified either as Day Care or as Resident
ZOOM
+
Nursing Home - Further Practice for Mapping EER-to-
Relational Model
Transform the following EER model and diagram into a normalised (3NF) relational model
Inidal
Surname
Frstname
NINO
DOB
Address
Telno
Religion
Name
Name
(1.3)
(1.1)
Patient
H
Next of Kin
Nursing
Home No
(1,1)
(1,n)
has
GP
Name
Telno
(1,1)
Day Care
Resident
Address
econ
Weekdays
1,1)
(1n)
Social
Worker
Teino
data
BaseLine
Allocated
Address
Collection
Time
is e
Arrival
Time
Pulse
Blood
Temp
pressure
(1,1)
Weight
Date
Assessment
Hygiene
(1,n)
Name
Addre
Telno
Sieep
Mobility
StattNe
Me
Job
Dress
Awa
Туре
Staff
Name
(1,3)
Address
(1.1)
(1,1)
Next of Kin
Primary Care
Nurse
Telno
The Name and addresses for the various entities are likely to be composite.
The various telephone numbers may be shown as multi-valued (home, mobile, ete)
II
Transcribed Image Text:ZOOM + Nursing Home - Further Practice for Mapping EER-to- Relational Model Transform the following EER model and diagram into a normalised (3NF) relational model Inidal Surname Frstname NINO DOB Address Telno Religion Name Name (1.3) (1.1) Patient H Next of Kin Nursing Home No (1,1) (1,n) has GP Name Telno (1,1) Day Care Resident Address econ Weekdays 1,1) (1n) Social Worker Teino data BaseLine Allocated Address Collection Time is e Arrival Time Pulse Blood Temp pressure (1,1) Weight Date Assessment Hygiene (1,n) Name Addre Telno Sieep Mobility StattNe Me Job Dress Awa Туре Staff Name (1,3) Address (1.1) (1,1) Next of Kin Primary Care Nurse Telno The Name and addresses for the various entities are likely to be composite. The various telephone numbers may be shown as multi-valued (home, mobile, ete) II
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
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