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

Exercise 8

A new purchase order processing system is being designed for a corporate client. The specifications that follow have been proposed for the purchases transaction file and the open purchase order file.

Transaction records are to be retrieved by transaction number, whereas open purchase order records are to be retrieved by purchase order number. The transaction file is to be purged once a month. The open purchase order file is permanent, although individual records will be purged after the order has been filled.
Required:
a. Analyze these file specifications and 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.