ER Diagram for Medical Store System: Entities, Relationships & Database Design
ER Diagram for a Medical Store System:
Entities:
* Medicine:
* MedicineID (primary key)
* Name
* Description
* Quantity
* Price
* Customer:
* CustomerID (primary key)
* Name
* Address
* PhoneNumber
* Sale:
* SaleID (primary key)
* CustomerID (foreign key)
* MedicineID (foreign key)
* Quantity
* TotalAmount
* Employee:
* EmployeeID (primary key)
* Name
* Role
Relationships:
* Customer purchases Medicine:
* One customer can purchase many medicines.
* One medicine can be purchased by many customers.
* This relationship is represented by the Sale entity.
* Employee works at Medical Store:
* One employee can work at only one medical store.
* Many employees can work at one medical store.
* This relationship is represented by the Employee entity.
Medical Facilities - Related Articles
- Laboratory Safety Guidelines: Essential Practices for a Secure Workspace
- Medical Assistant Certification: Governing Bodies & Credentialing
- Accessing Your Kaiser Permanente Health Records: A Comprehensive Guide
- Medical Receptionist Education Requirements: What You Need to Know
- Building a Culture of Medication Safety: A Guide for Healthcare Organizations
- PET Scans: What They Reveal About Your Health
- Physician Attire: A Guide to Scrubs and Lab Coats