CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 51

(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.
Medication MedicationID, MedicationName, Dosage, Cost,
QuantityOnHand, LastPurchasedDate, ReorderMinimum Identifies
the medication the hospital pharmacy dispenses. One or more
medications can be dispensed per prescription. The quantity on hand
allows Pharmacists to determine the inventory levels. The reorder
minimum can be used to determine when the inventory level has
reached a reorder point.