please do

Conceptual Design (cERD)

Logical ERD with relational schema

Normalization

DoD Payment Payment ID (PK) Payment type 1.1 Payment date Total price Update to 1.1 1..1 Staff inform Staff ID (PK) Staff Name Position Telephone No E-Mail Address 0.. 1.. 1..1 Customer Customer ID (PK) Customer Name E-Mail Address Telephone No. Address Ordered product Item quantity 1.. Deliver Shipment Shipment ID {PK) Shipment type Shipment Company name Shipment price 1..1 1..1 Admin Send Product Supplier Supplier ID {PK) Supplier Name E-Mail Address Telephone No 1... Admin_id {pk) Admin name Admin password * , , , 1.- Buy D Product Product ID (PK) Product Name Product category Product price Add 0.. 1.. 1... Check buyDate Order quantity Total order price