ER Diagram for a medical store system?

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.