CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 46

additional attributes are needed to better define an entity, then you
should add them.
Entities Attributes and Relationships for University Medical Center
(Parallel Lab Exercise):
Entity Attributes Relationships
HealthcareWorkerHealthcareWorkerID, LastName, FirstName, SSN,
Address, City, State, Zip, Phone Number, HealthcareWorkerTypeID A
healthcare worker can belong to any one of the three job categories,
but can belong to one and only one of the three. healthcare worker has
names and other contact information.
HealthcareWorkerTypeHealthcareWorkerTypeID,
HealthcareWorkerTypeDesc, HourlyBillingRate A healthcare worker
can be either a physician (diagnoses, prescribes medication), nurse
(provides physician-ordered treatments, administers medications), or a
pharmacist (dispenses, delivers medication).
ClinicLogClinicLogID, ClinicID, Login, Logout, HealthcareWorkerID
Patients may be treated by a healthcare worker at a clinic and can be
tracked by the clinic log number. A healthcare worker must sign into
the clinic before he or she can serve patients, and must sign out when
finished treating patients at that clinic. A healthcare worker may serve
portions of a shift at more than one clinic.
Clinic ClinicID, ClinicLocationDesc, AMAAccredNum The hospital
operates three clinical facilities: General Hospital, Midtown Clinic,
and Urgent Care.
InHomeCareInHomeCareID, HealthcareWorkerID, PrescriptionID,
DepartTime, ReturnTime. Relates to both the healthcare worker and
the prescription entities. This entity will help track provision of home