Question: Please provide me answer. Case Study: City Jail The City Jail organization is preparing to deploy the new database to four departments. The departments and
Please provide me answer.

Case Study: City Jail The City Jail organization is preparing to deploy the new database to four departments. The departments and associated duties for the database are described in the following chart: Number of Employees Duties Department Criminal Records 8 1. Add new criminals and crime charges 2. Make changes to criminal and crime charge data as 254 needed for corrections or updates 3. Keep the police officer information up to date 4. Maintain the crime codes list. 1. Enter and modify all court appeals information. 2. Enter and maintain all probation information. 3. Maintain the probation officer list. 1. Analyze all criminal and court data to identify trends. 2. Query all crimes data as needed to prepare federal Court Recording Crimes Analys is and state reports. Data officer 1. Remove crimes, court, and probation data based on approved requests from any of the other departments. Based on the department duties outined in the table, develop a plan to assign privileges to employees in all four departments. The plan should include the following A description of what types of objects are required A list of commands needed to address user creation for each department
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
