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 .