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.

Please provide me answer. Case Study: City Jail The City Jail organization

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!