Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann

Exercise 6

A new sales order processing system is being designed for a corporate client. During the initial design process, the specifications shown below have been proposed for the sales transaction file and the open sales order file.

Transaction records are to be retrieved by invoice number, whereas open sales order records are to be retrieved by sales order number. The transaction file is to be purged once a month. The open sales order file is permanent, although individual records will be purged after the order has been filled. Customer billing addresses are more or less permanent, but shipping addresses can vary from sale to sale because customers may request shipment to branch offices or field sites.
Required:
a. Analyze these file specifications to provide a normalized logical data structure defining the schema of a relational database management system. Provide tables of data elements describing your final normalized form.
b. Provide a data access diagram showing how the data records would be retrieved.