DAD 220 Analysis and Summary Template BROWN

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Feb 20, 2024

Type

docx

Pages

8

Uploaded by ChancellorKangaroo151

DAD 220 Analysis and Summary Template Replace the bracketed text in this template with your responses and any supporting screenshots. Then submit it to the Module Five Activity for grading and feedback. Rename this document by adding your last name to the file name before you submit. Table Creation: CREATE TABLE Parts_Maintenance (vehicle_id VARCHAR(20), state VARCHAR(2), repair VARCHAR(50), reason VARCHAR(50), year INT, make VARCHAR(20), body_type VARCHAR(50)); Data Into File: LOAD DATA INFILE '/home/codio/workspace/FleetMaintenanceRecords.csv' INTO Table Parts_Maintenance FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'; 1. Analyze the data you’ve been provided with to identify themes : a. Which parts are being replaced most?
From the information in the table below, it would appear as though the Fuel Tank is being replaced the most, with 95 replacements. This is followed by Tire Repair at 74 and Tire Replacement at 66. Command: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REPAIRS DESC; b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: 1. The results of my query show that the Midwest region experiences more part failures and replacements than any other region with 260 total
Command: SELECT 'SOUTHWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('AZ','NM','TX','OK') UNION SELECT 'SOUTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('AR','LA','MS','AL','GA','FL','KY','TN','SC','NC','VA','WV','DE','MD') UNION SELECT 'NORTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('PA','NJ', 'NY','CT','RI','MA','VT','ME','NH') UNION SELECT 'MIDWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('ND','SD','KS','NE','MN','WI','IA','MO','MI','IN','IL','OH') UNION SELECT 'WEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('WA','ID','MT','OR','WY','CO','UT','NV','CA') ORDER BY NUMBER_OF_REPAIRS DESC; ii. How might the fleet maintenance team use the information to update its maintenance schedule?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help