Diagnostic Radiology Service ERD Scenario:

The Diagnostic Radiology Service provides radiology procedures for outpatients. Use the entity descriptions and Business Rules described below to develop an ERD. Make sure all attributes included in the model are atomic $($cannot be further broken down$).$ Additionally, identify primary key attributes with the use of the unique $($underline$)$ in ERDPlus.com within your ER diagram. Foreign key attributes shouldn$$t be included in the ER diagram. You are required to use ERDPlus.com to construct the ER Diagram that will be submitted for this part $3$ requirement as a $.$PNG file.

Entities

Person

PersonID

Name

Address

HomePhone

CellPhone

Gender

Race

ReferringPhysician

PersonID

NationalPractitionerID

Specialty

Patient

PersonID

ReferringPhysician $($FK referencing physician's PersonID$)$

Employee

EmployeeID

DateHired

DateLastPromotion

Degree

HourlyRate

Technician

EmployeeID

Certification

Radiologist

EmployeeID

Specialty

Visit

PatientID

Date

VisitReason

RadiologyProcedure

RadiologyProcedureID

Name

Description

Additional ER Modeling Considerations:

Person is a supertype

Subtypes:

ReferringPhysician

Patient

A Person is not employed by the organization.

A Person must be at least one of the following:

Referring Physician or

Patient

A Person can be both a referring physician and a patient

Employee is a supertype

Subtypes:

Technician

Radiologist

An Employee is a Technician or a Radiologist $($cannot be both$),$ or other employee staff not modeled in the ERD scenario.

Patient to ReferringPhysician

One Referring Physician has many Patients

One Patient has one and only one Referring Physician

Referring Physician $1$:M Patient

Patient to Visit

One Patient has many Visits

One Visit relates to one and only one Patient

Patient $1$:M Visit

Visit to RadiologyProcedure

One Visit may contain many Radiology Procedures

One Radiology Procedure may be performed for many Visits

Visit M:N Radiology Procedure; Associative Entity: VisitProcedure

Radiologist to VisitProcedure

One Radiologist reads results from many VisitProcedures

One VisitProcedure result is read by one Radiologist

Radiologist $1$:M VisitProcedure

Technician to VisitProcedure

One Technician performs many VisitProcedures

One VisitProcedure is performed by one Technician

Technician $1$:M VisitProcedures