DAD 220 Analysis and Summary Medeiros

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Jan 9, 2024

Type

docx

Pages

8

Uploaded by rwmedeiros

Report
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. Explanation: Created a table names PartsMaintenance using the following command: CREATE TABLE PartsMaintenance (vehicle_id VARCHAR(20), state VARCHAR(2), repair VARCHAR(50), reason VARCHAR(50), year INT, make VARCHAR(20), body_type VARCHAR(50)); I was then able to show the command worked using the following show table command: show tables; 1. Analyze the data you’ve been provided with to identify themes :
a. Which parts are being replaced most? Explanation: Using the commands below: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS FROM PartsMaintenance GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REPAIRS DESC; We can identify that the “ Fule” tank (Fuel tank) is the most replaced part coming in at 95 replacements . b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: Explanation: We can identify which region of the country that experiences more part failures and replacements using the command below: SELECT 'SOUTHWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM PartsMaintenance WHERE UPPER(state) IN ('AZ','NM','TX','OK') UNION SELECT 'NORTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM PartsMaintenance WHERE UPPER(state) IN ('PA','NJ','NY','CT','RI','MA','VT','ME','NH') UNION SELECT 'SOUTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM PartsMaintenance WHERE UPPER(state) IN ('AR','LA','AL','GA','TN','SC','NC','VA','WV','DE','MD') UNION SELECT 'MIDWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM PartsMaintenance 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 PartsMaintenance WHERE UPPER(state) IN ('WA','ID','MT','OR','WY','CO','UT','NV','CA') ORDER BY NUMBER_OF_REPAIRS DESC; The result of this query identifies the Midwest as experiencing the most part failures with 260 repairs while the nest closest region is the Northeast with 208 repairs. Using the UNION command to combine the multiple results that were received from each SELECT statement that represented their own specific region. ii. How might the fleet maintenance team use the information to update its maintenance schedule? 1. Fleet Maintenance can use this information to alter their maintenance schedule. 2. More resources can be allotted to the regions with the highest number of repairs. 3. The team can from this point schedule and do more preventative maintenance in those higher regions. 4. Combining the previous tables with this information can also allow the inventory and logistics departments to use more warehouse space for the more pertinent parts that are needed. c. Which parts are being replaced most due to corrosion or rust? i.
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