The City Jail organization is preparing to deploy the new database to four departments. The departments and
Question:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 81% (11 reviews)
Depending on department duty interpretation This project should provide a good source for discussion For example given the Data Officer duty of data r...View the full answer
Answered By
Bhartendu Goyal
Professional, Experienced, and Expert tutor who will provide speedy and to-the-point solutions. I have been teaching students for 5 years now in different subjects and it's truly been one of the most rewarding experiences of my life. I have also done one-to-one tutoring with 100+ students and help them achieve great subject knowledge. I have expertise in computer subjects like C++, C, Java, and Python programming and other computer Science related fields. Many of my student's parents message me that your lessons improved their children's grades and this is the best only thing you want as a tea...
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
You have designed and created tables for the City Jail database. These tables dont include any constraints. Review the information to determine what constraints you might need for the City Jail...
-
1. The head DBA has requested the creation of a sequence for the primary key columns of the Criminals and Crimes tables. After creating the sequences, add a new criminal named Johnny Capps to the...
-
You designed the new database for City Jail. Now you need to create all the tables for the database. First, create all the tables using the information outlined in Section A. Second, make the...
-
SAE 10 oil at 20C flows in a vertical pipe of diameter 2.5 cm. It is found that the pressure is constant throughout the fluid. What is the oil flow rate in m3/h? Is the flow up or down?
-
At Franklis Incorporated, during the month of January, the direct labor rate variance was $3,000 unfavorable, and the direct labor efficiency variance was $5,000 favorable. Actual direct labor costs...
-
Find the areas of the shaded region. y = sec t 4 y 2 y = 1 - 1 0 1
-
What are the key macroeconomic objectives of government? Are there likely to be any conflicts between them?
-
A machine is purchased at the beginning of 2011 for $42,000. Its estimated life is eight years. Freight costs on the machine are $3,000. Installation costs are $1,600. The machine is estimated to...
-
How does emotional intelligence contribute to effective conflict resolution and negotiation strategies, enabling individuals to manage interpersonal conflicts constructively and navigate complex...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Use the JustLee Books database to perform the following activity: There are three major classifications for employees who dont work for the Information Systems Department of JustLee Books: account...
-
Which clause of an SQL query is used to restrict the number of rows returned?
-
Assume you are the senior in charge of the audit of a client in New York who offers you two tickets to the Super Bowl between the New York Giants and the Denver Broncos. The opportunity to see the...
-
Consider the following bonds: a. What is the percentage change in the price of each bond if its yield to maturity falls from 7% to 6%? b. Which of the bonds AD is most sensitive to a 1% drop in...
-
Your firm would like to evaluate a proposed new operating division. You have forecasted cash flows for this division for the next five years, and have estimated that the cost of capital is 11%. You...
-
Natashas Flowers, a local florist, purchases fresh flowers each day at the local flower market. The buyer has a budget of $970 per day to spend. Different flowers have different profit margins, and...
-
What is the maturity of a default-free security with annual coupon payments and a yield to maturity of 4.6%? Why? Maturity (years) Zero-coupon YTM 1 4.6% 2 5.0% 3 5.4% 4 5.8% 5 6.1%
-
Valley Forgings has identified four alternatives to meet its requirement for an additional production facility. The following table summarizes data gathered relative to each alternative. a. Calculate...
-
Research the use of WIKIs and address the concerns team members have about using them, and the fear of others "messing up their work"
-
14. In testing the existence assertion, an auditor ordinarily works from the a. Financial statements to the accounting records. b. General journal to the general ledger. c. Supporting evidence to the...
-
Experiment with the Message Segmentation applet at the books Web site. Do the delays in the applet correspond to the delays in the previous problem? How do link propagation delays affect the overall...
-
Skype offers a service that allows you to make a phone call from a PC to an ordinary phone. This means that the voice call must pass through both the Internet and through a telephone network. Discuss...
-
List five non-proprietary Internet applications and the application-layer protocols that they use.
-
List 3 different types of market segmentations. Let's hypothesize that you are the CEO of a hockey equipment company. Who would likely be your main market segment? Explain your answer. List 3...
-
what ways does the Multilevel Feedback Queue (MLFQ) scheduling algorithm address the complexities of modern computing environments by incorporating multiple priority levels and feedback mechanisms?
-
Part 1 : Use the table provided here to answer the questions below: 1) which attribute is the most important and what is the decision weight of each attribute 2) What is the market share between the...
Study smarter with the SolutionInn App