DAD 220 5-2 Activity Analysis and Summary Robert Adams

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Chemistry

Date

Dec 6, 2023

Type

docx

Pages

5

Uploaded by rma52513

DAD 220 5-2 Activity: Analysis and Summary by Robert Adams 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. Create a table called Parts Maintenance and load the data into it. Put this table in the database named after yourself. Load this data set from the ‘/home/codio/workspace’ path and run queries to find the results. 1. Analyze the data you’ve been provided with to identify themes : a. Which parts are being replaced most?
i. After sorting the number of part names starting with the highest number of issues, (and going by replacements only) tires are being replaced the most. Looking at the output, the top 3 issues are Fuel tanks, Tire repairs, and Tire replacements. b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: 1. The Midwest region experiences more part failures and replacements than others. (After initially calculating the total and seeing my numbers were off, I noticed DC was missing from the Northeast Region Definition list, but listed in the FleetMaintenanceRecords.csv file, so I added it just in case, bringing my total back to 805).
ii. How might the fleet maintenance team use the information to update its maintenance schedule? 1. The fleet maintenance team could use the information to provide priority maintenance schedules based off the higher number of parts that need repaired or replaced. They could also stock up more on parts that are in higher demand based off these records and supply more maintenance technicians to the areas that have higher rates of issues such as the Midwest and Northeast. c. Which parts are being replaced most due to corrosion or rust? i. The top 3 parts being replaced most due to corrosion or rust are Wheel Arch, Fender replacement, and Rocker Panel. d. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? i. Tire repairs, Tire replacements, and Windshield replacements are being replaced most because of mechanical failure or accidents such as flat tires or rocks through the windshield. (I included another screenshot including other possible parts needed for mechanical failures or accidents just in case it was looking for more than those two examples, such as collisions, dead batteries, and gear slipping issues)
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