HealthcareWorkerHealthcareWorkerID , LastName , FirstName , SSN , Address , City , State , Zip , Phone Number , HealthcareWorkerTypeID A healthcare worker can belong to 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 .