Er diagram for pharmacy management system?
Database
* Customer
* CustomerID (primary key)
* Name
* Address
* Phone
* Employee
* EmployeeID (primary key)
* Name
* Address
* Phone
* Doctor
* DoctorID (primary key)
* Name
* Address
* Phone
* Medicine
* MedicineID (primary key)
* Name
* Description
* Price
* Prescription
* PrescriptionID (primary key)
* DoctorID
* PatientID
* MedicineID
* Quantity
* Order
* OrderID (primary key)
* CustomerID
* EmployeeID
* Date
* Total
Relationships
* Customer has many Orders.
* Employee has many Orders.
* Doctor has many Prescriptions.
* Patient has many Prescriptions.
* Medicine has many Prescriptions.