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