Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

So this problem from Oracle 12c by Joan Casteel chapter 7 I need help to create this sql program plz Case Study: City Jail The

So this problem from Oracle 12c by Joan Casteel chapter 7 I need help to create this sql program plz image text in transcribed
Case Study: City Jail The City Jail organization is preparing to deploy the new database to four d departments and associated duties for the database are described in the followingh Number of Employees Duties Department Criminal Records 1. Add new criminals and crime charges. 2. Make changes to criminal and crime charge data 254 as needed for corrections or updates 3. Keep the police officer information up to date. 4. Maintain the crime codes list. Court Recording 1. Enter and modit al cour asppeals 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 Crimes Analysis 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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions