dolution

/in /by

dolution.

The city’s Crime Analysis unit has submitted the following data requests. Provide the SQL statements
using subqueries to satisfy the requests. Test the statements and show execution results.

1. List the name of each officer who has reported more than the average number of crimes officers
have reported.

2. List the names of all criminals who have committed less than average number of crimes and
aren’t listed as violent offenders.

3. List appeal information for each appeal that has a less than average number of days between
the filing and hearing dates.

4. List the names of probation officers who have had a less than average number of criminals
assigned.

5. List each crime that has had the highest number of appeals recorded.

6. List the information on crime charges for each charge that has had a fine above average and a
sum paid below average.

7. List the names of all criminals who have had any of the crime code charges involved in crime ID
10089.

8. Use a correlated subquery to determine which criminals have had at least one probation period
assigned.

9. List the names of officers who have booked the highest number of crimes. Note that more than
one officer might be listed.

Note: Use a MERGE statement to satisfy the following request:
10. The criminal data warehouse contains a copy of the CRIMINALS table that needs to be updated
periodically from the production CRIMINALS table. The data warehouse table is named
CRIMINALS_DW. Use a single SQL statement to update the data warehouse table to reflect any
data changes for existing criminals and to add new criminals.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

/in /by

dolution.

This is an individual, written submission assignment.

Reflect and Describe a problem you have encountered where the “root cause” was unknown to you. (If you have experience in Industry/Quality, please use a relevant example, without disclosing company-private information. If you do not have any industrial quality experience, try to name a problem that was recurring, and challenging to solve.)
Does your example qualify as a “quality” problem as discussed in this course? Why or why not? How would you describe its recurrence? Try to use our SMART template to describe the problem. What parts of our template apply or don’t?
Describe the process you followed to solve it. Would you consider your solution process to be a “structured problem solving” method? What key methods/tools did you use? Would a more formal process have helped?
Your submission should connect directly to the course material so far. If you have not yet experienced an “industry-type” quality problem, you can still answer the above, contrasting your example with an industrial problem – how are they different? How are the problem solving methods different and why? Could any of our course content still apply?

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

/in /by

dolution.

Homeruns Go to the book’s website to obtain the data file 12_2_22 using the file format of your choice for the version of the text you are using. The variable “TrueDist” represents the distance, in feet, that the homerun traveled for all homeruns hit in the 2014 season.

(a) Draw a relative frequency histogram of the distance a homerun traveled in 2014 using a lower class limit of the first class of 300 and a class width of 10. Describe the shape of the distribution.

(b) Find the population mean and population standard deviation distance.

(c) Find the quartiles of distance.

(d) Draw a boxplot of distance. Are there any outliers?

(e) Use a normal model to determine the proportion of homeruns that exceeded 450 feet. Compare this to the actual proportion of homeruns that exceeded 450 feet.

(f) Use a normal model to determine the first and third quartiles. Compare this result to the quartiles found in part (c).

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

/in /by

dolution.

At year-end, the accounting department at Bell-Jones Industries had prepared the following balance sheet and income statement.

Just prior to the arrival of the outside auditors, one of the accounting staff brought a list of items to the chief financial officer. The staff member was concerned that these items had not been properly accounted for in the financial statements.

1. A source document showing a customer’s return of goods had been missing until just now and had not been processed through the accounting system. The goods had been sold on account to the customer for 9,000 during the current year and were returned to the warehouse for sale to others. The company’s normal gross profit on sales is 30%.

2. Just before year-end, inventory had been purchased on credit at a cost of 60,000, FOB destination. By year-end, it had not yet arrived but it had been included in the ending inventory anyway.

3. At the end of the prior year, there was 80,000 of inventory in transit from a supplier. The goods had been purchased FOB shipping point but had not yet arrived. The goods had been included in last year’s ending inventory anyway.

4. An error had been made in computing the warranty costs for goods sold during the current year. A total of 55,000 had been charged to Warranty Expense, but the correct amount was 75,000.

5. Near year-end, a 100,000 service contract was obtained from a major customer. It was a renewal of an existing contract that would otherwise have expired during the coming year. Because this type of work had been performed many times before for this customer, the contract was entered into the accounting system as a credit sale during the year just ended. Collection of the cash will occur as the services are performed.

6. The adjusting entry to allowance for returns had not yet been recorded at year-end. Using the firm’s usual approach, an additional 10,300 should be recorded.

7. No adjusting entry had been made at year-end to account for doubtful accounts. Using the firm’s usual approach, 5,960 should be charged to expense.

Required

A. Show any entries to the accounting system that you believe should be made as a result of this information. If an item does not require an entry, explain why.

B. What is the proper amount of operating income that should be reported for the period? Prepare a schedule to show how you determined this amount.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"