need to do Relational database schemas.

Set of queries (minimum 15 queries) for each transaction for all users.

ERD Do Payment Payment ID {PK) Payment type Payment date Total price Update to 1..1 1..1 1..1 Staff 1..1 Inform Staff ID (PK) Staff Name Position 1... Telephone No E-Mail Address Customer 0..* Customer ID (PK) Customer Name E-Mail Address Telephone No. Address Ordered product Item quantity Deliver Shipment Shipment ID (PK) Shipment type Shipment Company name Shipment price 1..1 1., 1 0.." Supplier Send Product Supplier ID {PK) Supplier Name 1... E-Mail Address Telephone No 1.. Buy > Product Product ID {PK} Product Name Product category Product price Add 0..* 1.. 1.." Check buyDate Order quantity Total order price ERD Do Payment Payment ID {PK) Payment type Payment date Total price Update to 1..1 1..1 1..1 Staff 1..1 Inform Staff ID (PK) Staff Name Position 1... Telephone No E-Mail Address Customer 0..* Customer ID (PK) Customer Name E-Mail Address Telephone No. Address Ordered product Item quantity Deliver Shipment Shipment ID (PK) Shipment type Shipment Company name Shipment price 1..1 1., 1 0.." Supplier Send Product Supplier ID {PK) Supplier Name 1... E-Mail Address Telephone No 1.. Buy > Product Product ID {PK} Product Name Product category Product price Add 0..* 1.. 1.." Check buyDate Order quantity Total order price