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

Exercise 2

Using a system output approach to developing a database, you have determined that the accounting system needs to produce a purchase order for each purchase the organization places. The desired format of the purchase order is as follows:

Required:
a. What data elements need to be stored to produce the purchase order?
b. What are the three steps that should be taken to normalize the data you identified in Part a with respect to 3NF?
c. What tables should be in the database so the accounting system can produce a purchase order? Use data normalization to develop your tables.