INVENTORY - PowerPoint PPT Presentation

aerona
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
INVENTORY PowerPoint Presentation
play fullscreen
1 / 4
Download Presentation
INVENTORY
138 Views
Download Presentation

INVENTORY

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 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.]

  2. CUSTOMER S.O. INVENTORY

  3. CUSTOMER 1 M S.O. M M INVENTORY

  4. SO# Name Date Cust No, Addr Qty CUSTOMER 1 M S.O. M M Part # INVENTORY QoH Descr.