Per your request, Garden Glory identifies three groups of users managers, administrative personnel, and system administrators Suppose further that the only job of administrative personnel is to make Service Update Transactions Managers can make Service Update Transactions and Service Updates for New Employee Transactions System administrators have unrestricted access to the tables Project Question 1 Describe processing rights that you think would be appropriate for this situation Use the following template table as a guide and see Figure 6 16, pp 319 in textbook for an example What problems might this security system have DATABASE RIGHTS GRANTED Table Management Administrative System Administrator OWNER EMPLOYEE SERVICE PROPERTY Garden Glory has also developed an initial procedure for backup and recovery and asks you for evaluation The company backs up the database from the server to a second computer on its network each night Once a month, it copies the database to a CD and stores it at a manager's house It keeps paper records of all services provided for an entire year If it ever loses its database, it plans to restore it from a backup and reprocess all service requests Project Question 2 Do you think this backup and recovery program is sufficient for Garden Glory What problems might occur What alternatives exist Describe any changes you think the company should make to this backup and recovery procedure

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 24, 2024

Per your request, Garden Glory identifies three groups of users: managers, administrative personnel, and system administrators. Suppose further that the only job of administrative personnel

Per your request, Garden Glory identifies three groups of users: managers, administrative personnel, and system administrators. Suppose further that the only job of administrative personnel is to make Service Update Transactions. Managers can make Service Update Transactions and Service Updates for New Employee Transactions. System administrators have unrestricted access to the tables.

Project Question 1: Describe processing rights that you think would be appropriate for this situation. Use the following template table as a guide and see Figure 6-16, pp.319 in textbook for an example. What problems might this security system have?

DATABASE RIGHTS GRANTED
Table	Management	Administrative	System Administrator
OWNER
EMPLOYEE
SERVICE
PROPERTY

Garden Glory has also developed an initial procedure for backup and recovery and asks you for evaluation. The company backs up the database from the server to a second computer on its network each night. Once a month, it copies the database to a CD and stores it at a manager's house. It keeps paper records of all services provided for an entire year. If it ever loses its database, it plans to restore it from a backup and reprocess all service requests.

Project Question 2: Do you think this backup and recovery program is sufficient for Garden Glory? What problems might occur? What alternatives exist? Describe any changes you think the company should make to this backup and recovery procedure.