Using the following entity-relationship diagram for the partial order entry system.

(a) Write relationship sentences for all of the relationships.

(b) Discuss what each of the relationships mean in terms of how the business works.

(c) Does the business allow partial picks (i.e. only part of the goods on the sales order to be picked)?

(d) Does the business allow partial shipments (i.e. only part of the goods that have been picked to be shipped)?

(e) Are all shipments invoiced in full or partially (i.e. does the business allow partial invoices)?

Transcribed Image Text:

Customer places N Sales orders triggers Stock picking H N generates billed shipments Sales invoices to