ERD required for the question is attached.

The question is attached as well.

OrderDetails PK FK1 QrderlD PK,FK2 ProductD Unit Price Quantity Discount has Products PKK ProductD FK1 SupplierID CategoryID ProductName EnglishName Quantity PerUnit UnitPrice Unitsinstock UnitsOnorder ReorderLevel Discontinued has Suppliers PK SupplierID. Address City Province Orders 1 customerID FK FK2 EmployeelD ShipAddress ShipCity ShipPostalCode FK3 ShipperID Required Date Shipped Date Freigh has Shippers Company Name Customers PK CustomerID Company Name ContactTite -has--H Region PostalCode Country Phone Fax Employees PK Emplo LastName FirstName City Province PostalCode Phone BirthDate