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
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
6099025a38423_29334.pdf
180 KBs PDF File
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