6. Create a new spreadsheet called Audit Automation Summary in your Master Audit File and summarize your highlighted data elements from the three audit action sheets. Use the following headers: AAS# Table Attributes Values/Rules Step(s) Notes 7. Take a screenshot (label it 5- 3A). Q1. Read the first audit action sheet. What other data elements that are not listed in the procedures do you think would be useful in analyzing this account? Part 2: Identify the Location of the Data Now that you have analyzed the action sheets, look through the systems documentation to see where those elements exist. 8. In the Master Audit File, open the UML System Diagram and Data Dictionary files. 9. Using the data elements you identified in your Audit Automation Summary file, locate the actual names of tables and attributes and acceptable data values. Add them in three new columns in your summary: Database Table Database Attribute Acceptable Values Page 206 10. Take a screenshot (label it 5- 3B). Q2. Which attributes were difficult to locate or in unexpected places in the database? 11. Save and close your file. End of Lab D Values/Rules F Notes 1 AAS# Table Attributes Step(s) 2 1 User_Listing Name, Address, Zip 1, 2 Match supplier address and zip with customer address and zip. Similarity 50%. Evaluate list with the controller 3 1 Suppliers Name, Address, Zip 1,2,3 Search for missing data. Zip code = blank