Lab #2 Solution

Question 1:




Consider the following information:




Supplier:




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



Shipment:




Item:




ShipmentId, ShipmentDate, ShipmentTime




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



Question 2:

Provide the tables for the following ERD