Question 1:

Consider the following information:

Supplier:              SupplierId, SupplierName, SupplierAddress (The address consists of StreetName, AptNo, PostalCode)

Shipment:            ShipmentId, ShipmentDate, ShipmentTime

Item:                     ItemNo, ItemDescription, QuantityOnHand

One supplier can send many shipments; however, a particular shipment is only sent by one supplier. One item can be in many shipments and a shipment can include many items. A supplier can supply many items and a particular item can also be supplied by many suppliers.

1. Create your ERD.
2. Create associated tables