Question: 1 . Analyze the data provided in FleetMaintenanceRecords to identify themes. a . Review part - replacement frequencies and types. Then create a hypothesis that

1. Analyze the data provided in FleetMaintenanceRecords to identify themes.
a. Review part-replacement frequencies and types. Then create a hypothesis that the fleet management team can use to better handle maintenance.
i. Create a table called Parts Maintenance. Put this table in the database named after yourself.
ii. Load the data set from the /home/codio/workspace path and run queries to find the results. You should use the following line terminators when importing: \r
.
iii. Answer the following questions and provide supporting screenshots.
a) Which parts are being replaced most often?
[Insert your response and screenshot here.]
b) Which region or regions of the country experience more part failures and replacements than others?
a. Identify the region or regions with more reasons for the replacement of parts.
b. Use the Region Definitions sheet to identify states in each region.
[Insert your response and screenshot here.]
c) How might the fleet maintenance team use the information to update its maintenance schedule?
[Insert your response and screenshot here.]
d) Which parts are being replaced most often due to corrosion or rust?
[Insert your response here.]
e) Which parts are being replaced most often because of mechanical failure or an accident like a flat tire or rock through the windshield?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!