CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 45

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 healthcare. A healthcare worker can
provide many home visits but a prescription is administered on a
home visit by one and only one healthcare worker.
Method MethodID, Method Description Relates to medication and
identifies the method of administration, for example, oral, injection,
and so on.