ISM4113 - Business Systems Design

"My" way of implementing the database problem illustrated in Figure 9.3 of the text

I have simplified (somewhat) the example provided in Figure 9.3, pages 292-293 in the text. I have eliminated the INVOICE and SHIPMENT files. The INVOICE file served simply to establish a relationship between Order Number in the ORDER file and Invoice Number in the SHIPMENT file. The SHIPMENT file stored the actual quantity shipped to the customer. This field, Ship_Quantity, has been included in the LINE_ITEM file. Otherwise the logic is identical to the text example. You can download the Access database that illustrates how I implemented the files.

This is the Conceptual Data Model Diagram to support my way of implementing the databases.

Return to Chapter 6-9 Notes page