use sql to answer the following question an erd had been provideList all police officers who are assigned to the precinct OCVW or GHNT and have a status of active. List the officer ID, last name, precinct, and status. Sort the list by precinct and then by officer last name. COMP122_W21_ERS_100.PROB_CONTACTPROB_CATNUMBER (2)LOW_AMTNUMBER (5)NUMBER (5)VARCHAR2 (20 BYTE)HIGH_AMTCON_FREQCOMP122_W21_ERS_100.CRIMESCOMP122_W21_ERS_100.APPEALSP * CRIME_IDF * CRIMINAL_IDNUMBER (9)APPEAL_IDNUMBER (5)NUMBER (6)FCRIME_IDNUMBER (9)CLASSIFICATIONCHAR (1 BYTE)DATEDATE_CHARGEDDATECOMP122_W21_ERS_100.FILING_DATEHEARING_DATEDATESTATUSCHAR (2 BYTE)CRIME_CHARGESHEARING_DATENUMBENUMBENUMBECHAR (NUMBENUMBENUMBEDATECHARGE_ID*STATUSCHAR (1 BYTE)APPEAL_CUT_DATEDATECRIME_ID- APPEALS_ID_PK (APPEAL_ID)DATE_RECORDEDDATECRIME_CODEAPPEALS_CRIMEID_FK (CRIME_ID)- CRIMES_ID_PK (CRIME_ID)CHARGE_STATUSFINE_AMOUNTAPPEALS_ID_PK (APPEAL_ID)CRIMES_CRIMINALID_FK (CRIMINAL_ID)COURT_FEECRIMES_ID_PK (CRIME_ID)AMOUNT_PAIDPAY_DUE_DATEDATECRIMECHARGES_ID_PK (CHARCRIMECHARGES_CODE_FK (CFCRIMECHARGES_CRIMEID_FKCOMP122_W21_ERS_100.CRIME_CODESP *NUMBER (3)VARCHAR2 (30 BYTE)CRIME_CODECRIMECHARGES_ID_PK (CHARCODE_DESCRIPTIONCOMP122_W21_ERS_100.CRIME_OFFICERSCRIMECODES_CODE_PK (CRIME_CODE)PF* CRIME_IDPF* OFFICER_IDNUMBER (9)NUMBER (8)CRIMECODES_CODE_PK (CRIME_CODE)> CRIMEOFFICERS_CID_OID_PK (CRIME_ID, OFFICER_ID)COMP122_W21_ERS_100.CRIMINALSCRIMEOFFICERS_CRIMEID_FK (CRIME_ID)P * CRIMINAL_IDNUMBER (6)CRIMEOFFICERS_OFFICERID_FK (OFFICER_ID)LASTVARCHAR2 (15 BYTE)CRIMEOFFICERS_CID_OID_PK (CRIME_ID, OFFICER_ID)FIRSTVARCHAR2 (10 BYTE)VARCHAR2 (30 BYTE)VARCHAR2 (20 BYTE)CHAR (2 BYTE)CHAR (5 BYTE)CHAR (10 BYTE)STREETCITYSTATECOMP122_W21_ERS_100.ZIPALIASESPHONEV_STATUSP_STATUSCHAR (1 BYTE)CHAR (1 BYTE)* ALIAS_IDNUMBER (6)CRIMINAL_IDNUMBER (6)ALIASVARCHAR2- CRIMINALS_ID_PK (CRIMINAL_ID)COMP122_W21_ERS_100.ALIASES_ID_PK (ALIAS_ID)CRIMINALS_ID_PK (CRIMINAL_ID)OFFICERS* OFFICER_IDNUMBER (8)APPEALS_CRIMINALID_FK (CRIVARCHAR2 (1VARCHAR2(1CHAR (4 BYTVARCHAR2 (1CHAR (10 BY|CHAR (1 BYTLASTALIASES_ID_PK (ALIAS_ID)FIRSTPRECINCTBADGEPHONECOMP122_W21_ERS_100.PROB_OFFICERSSTATUSPROB_IDNUMBER (5)VARCHAR2 (15 BYTE)VARCHAR2 (10 BYTE)- OFFICERS_ID_PK (OFFICER_IDLASTOFFICERS_ID_PK (OFFICER_IDFIRSTVARCHAR2 (30 BYTE)VARCHAR2 (20 BYTE)CHAR (2 BYTE)CHAR (5 BYTE)CHAR (10 BYTE)VARCHAR2 (30 BYTE)CHAR (1 BYTE)STREETCITYSTATEZIPCOMP122_W21_ERS_100.SENTENCESPHONEPSENTENCE_IDNUMBER (6)EMAILF * CRIMINAL_IDNUMBER (9)STATUSΤΥΡECHAR (1 BYTE)MGR_IDNUMBER (5)FPROB_IDNUMBER (5)PAGER#CHAR (10 BYTE)START_DATEDATE- PROBOFFICERS_ID_PK (PROB_ID)END_DATEDATEVIOLATIONSNUMBER (3)PROBOFFICERS_ID_PK (PROB_ID)- SENTENCES_ID_PK (SENTENCE_ID)SENTENCES_CRIMEID_FK (CRIMINAL_ID)SENTENCES_PROBID_FK (PROB_ID)SENTENCES_ID_PK (SENTENCE_ID)P F

Dear Student, SQL query for your question is given below -

use sql to answer the following question an erd had been provide List all police officers who are assigned to the precinct OCVW or GHNT and have a status of active. List the officer ID, last name, precinct, and status. Sort the list by precinct and then by officer last name.

use sql to answer the following question an erd had been provide List all police officers who are assigned to the precinct OCVW or GHNT and have a status of active. List the officer ID, last name, precinct, and status. Sort the list by precinct and then by officer last name.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 2.11CP

See similar textbooks

Related questions

Q: Write SQL queries to answer the following questions:a. Which students have an ID number that is less…

A: a) SELECT * FROM STUDENT WHERE STUDENT_ID <5000; b) SELECT FACULTY_NAME FROM FACULTY WHERE…

Q: ts: You will need to add data to both tables. Remember that the movie table has th duction co., not…

A: Description: 1- If a user wants to insert records one by one then needs to use the following…

Q: Every guide receives their first review 6 months after their hire date. List the guide’s last name,…

A: SQL query to display all the list of the guide’s last name, first name, hire date, and his/her first…

Q: Given the table, EMPLOYEES below with the following rows, how many rows are generated by the SQL…

A: c. 1

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You…

A: In this database problem, we are tasked with creating an SQL query that lists the names of all…

Q: PL/SQL please use oracle sql developer. I know it would be hard to slove without the data but please…

A: Query for passenger info between dates.

Q: By using this table answer this question in SQL: Show the department id, department name and the…

A: Given: Show the department id, department name, and the number of employees working in any…

Q: Using today’s date, determine the age (in months) of each book that JustLee sells. Make sure only…

A: SELECT title, pubdate, SYSDATE, TRUNC(MONTHS_BETWEEN(SYSDATE, pubdate),0)Age FROM books;…

Q: List the item ID, description, and category for each pair of items that are in the same category.…

A: ANSWER:-

Q: Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of…

A: According to the question below the solution:

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

use sql to answer the following question an erd had been provide

List all police officers who are assigned to the precinct OCVW or GHNT and have a status of active. List the officer ID, last name, precinct, and status. Sort the list by precinct and then by officer last name.

COMP122_W21_ERS_100.PROB_CONTACT
PROB_CAT
NUMBER (2)
LOW_AMT
NUMBER (5)
NUMBER (5)
VARCHAR2 (20 BYTE)
HIGH_AMT
CON_FREQ
COMP122_W21_ERS_100.CRIMES
COMP122_W21_ERS_100.APPEALS
P * CRIME_ID
F * CRIMINAL_ID
NUMBER (9)
APPEAL_ID
NUMBER (5)
NUMBER (6)
F
CRIME_ID
NUMBER (9)
CLASSIFICATION
CHAR (1 BYTE)
DATE
DATE_CHARGED
DATE
COMP122_W21_ERS_100.
FILING_DATE
HEARING_DATE
DATE
STATUS
CHAR (2 BYTE)
CRIME_CHARGES
HEARING_DATE
NUMBE
NUMBE
NUMBE
CHAR (
NUMBE
NUMBE
NUMBE
DATE
CHARGE_ID
*
STATUS
CHAR (1 BYTE)
APPEAL_CUT_DATE
DATE
CRIME_ID
- APPEALS_ID_PK (APPEAL_ID)
DATE_RECORDED
DATE
CRIME_CODE
APPEALS_CRIMEID_FK (CRIME_ID)
- CRIMES_ID_PK (CRIME_ID)
CHARGE_STATUS
FINE_AMOUNT
APPEALS_ID_PK (APPEAL_ID)
CRIMES_CRIMINALID_FK (CRIMINAL_ID)
COURT_FEE
CRIMES_ID_PK (CRIME_ID)
AMOUNT_PAID
PAY_DUE_DATE
DATE
CRIMECHARGES_ID_PK (CHAR
CRIMECHARGES_CODE_FK (CF
CRIMECHARGES_CRIMEID_FK
COMP122_W21_ERS_100.CRIME_CODES
P *
NUMBER (3)
VARCHAR2 (30 BYTE)
CRIME_CODE
CRIMECHARGES_ID_PK (CHAR
CODE_DESCRIPTION
COMP122_W21_ERS_100.CRIME_OFFICERS
CRIMECODES_CODE_PK (CRIME_CODE)
PF* CRIME_ID
PF* OFFICER_ID
NUMBER (9)
NUMBER (8)
CRIMECODES_CODE_PK (CRIME_CODE)
> CRIMEOFFICERS_CID_OID_PK (CRIME_ID, OFFICER_ID)
COMP122_W21_ERS_100.CRIMINALS
CRIMEOFFICERS_CRIMEID_FK (CRIME_ID)
P * CRIMINAL_ID
NUMBER (6)
CRIMEOFFICERS_OFFICERID_FK (OFFICER_ID)
LAST
VARCHAR2 (15 BYTE)
CRIMEOFFICERS_CID_OID_PK (CRIME_ID, OFFICER_ID)
FIRST
VARCHAR2 (10 BYTE)
VARCHAR2 (30 BYTE)
VARCHAR2 (20 BYTE)
CHAR (2 BYTE)
CHAR (5 BYTE)
CHAR (10 BYTE)
STREET
CITY
STATE
COMP122_W21_ERS_100.
ZIP
ALIASES
PHONE
V_STATUS
P_STATUS
CHAR (1 BYTE)
CHAR (1 BYTE)
* ALIAS_ID
NUMBER (6)
CRIMINAL_ID
NUMBER (6)
ALIAS
VARCHAR2
- CRIMINALS_ID_PK (CRIMINAL_ID)
COMP122_W21_ERS_100.
ALIASES_ID_PK (ALIAS_ID)
CRIMINALS_ID_PK (CRIMINAL_ID)
OFFICERS
* OFFICER_ID
NUMBER (8)
APPEALS_CRIMINALID_FK (CRI
VARCHAR2 (1
VARCHAR2(1
CHAR (4 BYT
VARCHAR2 (1
CHAR (10 BY|
CHAR (1 BYT
LAST
ALIASES_ID_PK (ALIAS_ID)
FIRST
PRECINCT
BADGE
PHONE
COMP122_W21_ERS_100.PROB_OFFICERS
STATUS
PROB_ID
NUMBER (5)
VARCHAR2 (15 BYTE)
VARCHAR2 (10 BYTE)
- OFFICERS_ID_PK (OFFICER_ID
LAST
OFFICERS_ID_PK (OFFICER_ID
FIRST
VARCHAR2 (30 BYTE)
VARCHAR2 (20 BYTE)
CHAR (2 BYTE)
CHAR (5 BYTE)
CHAR (10 BYTE)
VARCHAR2 (30 BYTE)
CHAR (1 BYTE)
STREET
CITY
STATE
ZIP
COMP122_W21_ERS_100.SENTENCES
PHONE
P
SENTENCE_ID
NUMBER (6)
EMAIL
F * CRIMINAL_ID
NUMBER (9)
STATUS
ΤΥΡE
CHAR (1 BYTE)
MGR_ID
NUMBER (5)
F
PROB_ID
NUMBER (5)
PAGER#
CHAR (10 BYTE)
START_DATE
DATE
- PROBOFFICERS_ID_PK (PROB_ID)
END_DATE
DATE
VIOLATIONS
NUMBER (3)
PROBOFFICERS_ID_PK (PROB_ID)
- SENTENCES_ID_PK (SENTENCE_ID)
SENTENCES_CRIMEID_FK (CRIMINAL_ID)
SENTENCES_PROBID_FK (PROB_ID)
SENTENCES_ID_PK (SENTENCE_ID)
P F

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1 Explaination

VIEW

Step 2 SQL Query

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Alert dont submit AI generated answer.
Name the candidate keys in the following table: Student L number Student Name Student_SS_Number Student_Address Student City Student State LO005485 Leigh 811-47-4449 5744 KENSINGTON Ave. Boston MD LO004812 Tammy 441-79-7448 30936 OAK Alley Colorado Springs TX LO004415 Alfredo 375-78-2633 5115 BOWEN St. Kansas City VT LO003478 Ramona 360-82-2835 5097 HUBBARD LOWER Blvd. Miami PA LO003058 Crystal 528-16-2635 73192 RANDOLPH SUB Dr. Riverside MD LO004588 Angie 765-16-4433 5115 GROVELAND PARK Dr. Cincinnati FL L0005484 Tonya 410-76-3632 5115 BISHOP FORD Blvd. Irving MS LO003161 Preston 451-47-2634 95289 MONROE Ave. Boston NC HTM B I A - A - I E E E E E X X, E E D T T 12pt Paragraph
ID At_fault_claims 1001 0 1001 1 1002 0 1002 1 1002 1 1003 0 1004 1 1005 1 1005 0 Aggregate the the dataframe above at the ID to create the following claim count variables: : Number of At Fault claims Number of Not At Fault claims it should be written with python We should now have two additional columns 'at fault count' and 'not at fault count' in our aggregate dataframe
Normalization Diagram. See the attached picture.
Write a servlet to display a table that contains factorials for thenumbers from 0 to 10, as shown in Figure .
Estem.org/courses/64525/assignments/9460783?module_item_id=18078917 The following information can help you get started: • Invitation Details: it boils down to when and where o When: Time and date • Where: Address • Invitee List: Name and email • Name: First Name, or First Name and Last Name Email: Email address . Other considerations: After you complete your invitation, answer the following questions: 1. What type of data are time, date, and place? How are they different from the other data types on the invite and guest list? F4 A Additional information worth including: dress code, directions, gifting, how to contact you. . How will you know who is showing up? RSVP? . Is there a theme to your invitation/design? x F5 % F6 F7 DELL F8 F9 ROMNA F10 F11 PrtScr
Task 8: Create the DEL_OWNER procedure to delete the owner whose number is stored in I_OWNER_NUM (provided as a parameter).
Correct Query from table given.
osted.cuny.edu/webapps/assessment/take/launch.jsp?course_assessment_id%3D_1787700_1&course id3_1950256_1&content id%3_55349866 1&step%3Dnull * Question Completion Status: Given a truth table below with the first two columns of truth values provided: b. f(p,q) 1 2. F 4 Which of the answers below contains the truth values for the third column when f(p,q) ? Column 3 truth values: Column3 truth values: Column 3 truth values: Column 3 truth values: Column 3 truth values: 1 T 1 T 1F 1 T 1 F None of the other O 2 E O2 T O2 F 2 T 2 T Oanswers provided is correct. 3 T 3 T 3 T 3 F 3 T 4 F 4 T 4 F 4 T 4 T Chck Save and Submit to save and subrmi.Chick SaueAllansuersto save all answers. Save All Answers o search 99+ T. FT F. 3.
Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438? 3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4. Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?