Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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).

Step by Step Solution

3.48 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

1 Tables of the data access needs of the user The data is accessed by administrators who are the apa... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Document Format ( 2 attachments)

PDF file Icon
6099025a38423_29334.pdf

180 KBs PDF File

Word file Icon
6099025a38423_29334.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial and Managerial Accounting

Authors: Horngren, Harrison, Oliver

3rd Edition

978-0132497992, 132913771, 132497972, 132497999, 9780132913775, 978-0132497978

More Books

Students also viewed these Databases questions

Question

In 25 words or fewer, explain adjusting journal entries.

Answered: 1 week ago