Question
Show a diagram of the conceptual model including the following: 1. At least six entities and at least six relationships using the examples below. 2.
Show a diagram of the conceptual model including the following:
1. At least six entities and at least six relationships using the examples below.
2. 10 business rules in both forward and reverse relationship sentence structure
Entity: Hospital
Attributes: Hospital Name, Main Address, Main Phone Number
Primary Key: Hospital Name
Foreign Key: None
Relationships:
o 1-to-many: Department
o 1-to-many: Room
o 1-to-many: Doctor
Entity: Department
Attributes: Hospital Name, Department Name, Department Office Location, Department Phone Number
Primary Key: Hospital Name + Department Name
Foreign Key(s):
o Hospital Name in Hospital
Relationships:
o many-to-1: Hospital
Entity: Room
Attributes: Hospital Name, Room Number, Patient ID
Primary Key: Hospital Name + Room Number
Foreign Key(s):
o Hospital Name in Hospital
o Patient ID in Patient
Relationships:
o many-to-1: Hospital
o 1-to-1: Patient
Entity: Doctor
Attributes: NPI Number, Last Name, First Name, Degree, Specialty, Hospital Name
Primary Key: NPI Number
Foreign Key(s):
o Hospital Name in Hospital
Relationships:
o many-to-1: Hospital
o 1-to-many:
o DoctorPatient
o
Entity: Nurse
Attributes: Employee ID, Last Name, First Name, Hospital Name, Department Name
Primary Key: Employee ID
Foreign Key(s):
o Hospital Name in Hospital
o Hospital Name + Department Name in Department
Relationships:
o many-to-1: Hospital
o many-to-1: Department
Entity: Patient
Attributes: Patient ID, Hospital Name, Last Name, First Name, Room Number
Primary Key: Patient ID
Foreign Key(s):
o Hospital Name in Hospital
o Hospital Name + Room Number in Room
Relationships:
o many-to-1: Hospital
o 1-to-1: Room
o 1-to-many: DoctorPatient
Entity: DoctorPatient
Attributes: NPI Number, Patient ID
Primary Key: NPI Number, Patient ID
Foreign Key(s):
o NPI Number in Doctor
o Patient ID in Patient
Relationships:
o many-to-1: Doctor
o many-to-1: Patient
Entity: NursePatient
Attributes: Employee ID, Patient ID
Primary Key: Employee ID, Patient ID
Foreign Key(s):
o Employee ID in Nurse
o Patient ID in Patient
Relationships:
o many-to-1: Nurse
o many-to-1: Patient
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started