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

Exercise 9

A project manager in the organization where you are the controller wants to get a weekly report on each project she supervises. After spending some time with the manager to determine what data need to be on the report, you and the manager have agreed on the following format for the report:

Required:
a. What data elements need to be stored to produce each project report?
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 project report? Use data normalization to develop your tables.