The apartment managers at Wild Wood like what you have done so far, but as the database

Fantastic news! We've Found the answer you've been seeking!

Question:

The apartment managers at Wild Wood like what you have done so far, but as the database takes shape, they have begun to worry about security. The tenant information should not be accessible to just anyone. And they would like to keep the financial information internal, and not let outsiders or other companies see the details of their operation.

Required:

1. Create tables of the data access needs of your users.

2. Create a security plan that includes authentication and authorization and general policies and procedures. Consider the use of roles, stored procedures, views, and other tools.

3. Documentation: Document and define all the aspects of your plan.

4. Create a preliminary threat analysis.

5. Make a preliminary disaster management plan.

6. Create a view of the data that is tailored to the needs of one of your uses.

7. For extra credit, create a stored procedure that executes one of the basic activities for your database (making a rent payment, for instance, or a maintenance request).