Description
Do the homework in the pdf below
Unformatted Attachment Preview
CS443 – Assignment 2
Question 1:
Consider the following information:
Supplier:
PostalCode)
Shipment:
Item:
SupplierId, SupplierName, SupplierAddress (The address consists of StreetName, AptNo,
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.
a) Create your ERD.
b) Create associated tables
Question 2:
Provide the tables for the following ERD
Question 3:
Provide the tables for the following ERD
Purchase answer to see full
attachment
