Pharmacy Management System ER Diagram & Database Design
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.
Drug Treatment Centers - Related Articles
- Pennsylvania Adolescent Drug & Alcohol Rehab Centers | Clearbrook
- Alcohol Treatment Centers: Find Support & Recovery
- Pharmacy Training Programs: Duration & Requirements by Country
- Understanding Ear Drops: Key Ingredients and Uses
- Naproxen EC: Understanding Aleve & Midol for Pain Relief
- Creating Effective Substance Abuse Treatment Programs: A Comprehensive Guide
- Understanding Leaving a Drug Recovery Program: Medical Advice & Refusal of Care