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:

Based on the department duties outlined 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

Transcribed Image Text:

Number of Department Employees Duties 1. Add new criminals and crime charges. Criminal Records 2. Make changes to criminal and crime charge data as 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. Court Recording 2. Enter and maintain all probation information. 3. Maintain the probation officer list. 1. Analyze all criminal and court data to identify trends. Crimes Analysis 2. Query all crimes data as needed to prepare federal and state reports. 1. Remove crimes, court, and probation data based on approved requests from any of the other departments. Data officer