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.
- Create your ERD.
- Create associated tables
