EER (Enhanced Entity Relationship) diagram: E Employee o date_hired : date works in Person o person_ID: int name : string address : string birth_date date phone number : string is a is a v Volunteer o skill: string (N) Nurse o certificate : string is a (C) CareCentre o location : string isAppointedNurselnCharge is a P Physician o specialty : string o pager_number : string refers << (Pt, #FF7700) >> Patient o contact_date: date I) Item o item_number: int description : string unit_cost: decimal consumes/isConsumed TTechnician o skill : string L Laboratory o location : string performs performs «(Tr, #FF7700)>> Treatment o treatment_ID: string B Bed o bed_number: int room_number: int s Staff o job_class: string « (Vt, #FF7700) >> Visit o date : date comments: string

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Map the EER diagram to a relational schema and transform the relation into 3NF

EER (Enhanced Entity Relationship) diagram:
E Employee
o date_hired : date
works in
Person
o person_ID: int
name : string
address : string
birth_date date
phone number : string
is a
is a
v Volunteer
o skill: string
(N) Nurse
o certificate : string
is a
(C) CareCentre
o location : string
isAppointedNurselnCharge
is a
P Physician
o specialty : string
o pager_number : string
refers
<< (Pt, #FF7700) >>
Patient
o contact_date: date
I) Item
o item_number: int
description : string
unit_cost: decimal
consumes/isConsumed
TTechnician
o skill : string
L Laboratory
o location : string
performs performs
«(Tr, #FF7700)>>
Treatment
o treatment_ID: string
B Bed
o bed_number: int
room_number: int
s Staff
o job_class: string
« (Vt, #FF7700) >>
Visit
o date : date
comments: string
Transcribed Image Text:EER (Enhanced Entity Relationship) diagram: E Employee o date_hired : date works in Person o person_ID: int name : string address : string birth_date date phone number : string is a is a v Volunteer o skill: string (N) Nurse o certificate : string is a (C) CareCentre o location : string isAppointedNurselnCharge is a P Physician o specialty : string o pager_number : string refers << (Pt, #FF7700) >> Patient o contact_date: date I) Item o item_number: int description : string unit_cost: decimal consumes/isConsumed TTechnician o skill : string L Laboratory o location : string performs performs «(Tr, #FF7700)>> Treatment o treatment_ID: string B Bed o bed_number: int room_number: int s Staff o job_class: string « (Vt, #FF7700) >> Visit o date : date comments: string
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education