Lab 5 of 6: Auditing and Data Security (70 Points)

Lab Overview

Scenario/Summary

IMPORTANT: Read through the materials found in the Lab Resources Folder in the Files section. This material contains instructions for logging in to the Lab and creating and securing your database(s) for use in this course, as well as other useful instructions and information. It would be a good idea to print this information and have it handy when doing your labs.

Download the Lab Instructions and the Lab Report for the necessary steps to be completed for this Lab. They can be found in the Files section under the Lab category. Complete this template Lab report document by completing the sections listed on the page (Objectives, Results, and Conclusions). You will notice that the readings (including lectures), the examples we worked on during the lecture, and other audio and visual aids provided will all help you tackle this week’s Lab. Remember to always follow the instructions to get maximum credit, and use the weekly discussion related to the Lab and the Course Q & A Forum for additional help. Be specific and state the problem you are having clearly, including what you have done to resolve it, in the discussion.

Deliverables

Please save the completed Word document using the following naming convention: Save it personalized as flastnameLab05, where f is your first initial, followed by your last name and the original file name Lab05.

Do not include .docx; Word will finish with the .docx extension (e.g., Tom Brews would use “tbrewsLab05” and Word would finish with .docx).

Submit your Lab.

Lab Steps

STEP 1: Lab Report

The report cover sheets must be completed for all Labs. The key parts of these sheets include the following.

• Objective: Provide a one- or two-sentence explanation of the purpose of the Lab.
• Results: Give a statement of the final output, such as what will make this Lab successful.
• Conclusions: Conclusions should be based on the results, usually directly related to the purpose of the Lab.
• Observations and measurements: All results from the Lab must be recorded on the cover sheets. Turn in the cover sheets for grading and retain the remainder of the Lab as worksheets.