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

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.
PrescribedMedicationPrescriptionID, MedicationID, ItemPrice,
QuantityDispensed Prescribed medication is part of a prescription and
records medication dispensed per prescription. Prescribed medication