Here are the instructions:
You are to read and do the City Jail assignment at the end of Chapter 7 on page 254. Write your plan as specified as well as the script for user creation -this script will not run since we are not authorized to create users. Just select ONE DEPARTMENT (not the four stated) for your assignment.
?? @ oracle-1 2c-sal.pdf + ? ? O ? file://cyusers/j oracle 12c_sql.pdf 277 of 627 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 1. Add new criminals and crime charges. 2. Make changes to eriminal and crime charge data as 254 nceded 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 eriminal and court data to identify trends. 2. Query all erimes data as needed to prepare federal Court Recordi Crimes Analysis and state reports. Dats officer 1. Remove crimes, court, and probation data based on approved requests from any of the other departments. 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 needad lo address user creation for each department 6-24 PM O Type here to search ?? @ oracle-1 2c-sal.pdf + ? ? O ? file://cyusers/j oracle 12c_sql.pdf 277 of 627 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 1. Add new criminals and crime charges. 2. Make changes to eriminal and crime charge data as 254 nceded 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 eriminal and court data to identify trends. 2. Query all erimes data as needed to prepare federal Court Recordi Crimes Analysis and state reports. Dats officer 1. Remove crimes, court, and probation data based on approved requests from any of the other departments. 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 needad lo address user creation for each department 6-24 PM O Type here to search
