1) Suppose Garden Glory identifies three groups of users: managers, administrative per- sonnel, and system administrators

Subject:Computer SciencePrice:2.87 Bought7

Share With

1) Suppose Garden Glory identifies three groups of users: managers, administrative per- sonnel, 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 administra- tors have unrestricted access to the tables. Describe processing rights that you think would be appropriate for this situation. Use Figure 6-19 as an example. What prob- lems might this security system have?

2. Garden Glory has developed the following procedure for backup and recovery. 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. 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 system.