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