Instructions: 1) Draw the ERD, 2) addthree fields/attributes per entity. 3) Underline the primary key (aka “key field”) for each entity. 4) Add cardinality Sales orders are prepared for the customers. The sales order may contain multiple inventory items. [For this exercise, assume that all orders are completely filled – there are no partial orders.]
CUSTOMER S.O. INVENTORY
CUSTOMER 1 M S.O. M M INVENTORY
SO# Name Date Cust No, Addr Qty CUSTOMER 1 M S.O. M M Part # INVENTORY QoH Descr.