CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 35

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.
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;
• made by one or more pharmacists but only one pharmacist per prescription;
• recorded on one or more clinics but only one clinic per prescription; and
• administered by one or more nurses but no one prescription can be administered by
more than one nurse.