CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 47

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.
Prescription PrescriptionID, MedicationID, BillingAmount,
TransactionDateTime, ClinicLogID, PatientID A prescription is
identified by a single prescription order. Prescriptions are
• made to one or more patients but only one patient at a time;