(Solved): 3. Transform the Entity Relationship Diagram (ERD) in Figure 1 below into a relational model. Sh ...

3. Transform the Entity Relationship Diagram (ERD) in Figure 1 below into a relational
model. Show referential integrity.
Room_no
Bed Id
Degree
Specialty
StopDate
StartDate
CCLocation
BED
Phone
Date
hired
Bed_no
EmpID
NURSE
Works in
Type
CARECENTER
contains
Name
EMPLOYEE
JobClass
d
StartDate
Address
STAFF
Assigned to
CCName
City
Birthdate
StopDate
Figure 1: Enhanced Entity Relationship Diagram
State
Zip
Email_
Address
TECHNICIAN
techskill
Is assigned
LABORATORY
Lab
Location
LabName
(10 Marks)