Huffman Trucking Maintenance Database

Huffman Trucking Maintenance Database

Huffman Trucking started business 76 years ago and is a private owned transportation company. The company has worked his way up to a multimillion-dollar company with more than 1,400 employees and hundreds of vehicles. The company is looking for a way how they can track the maintenance on their fleet of tractors, trailer, and the roll-on/roll-offs. Under this new ideal, the fleet must undergo periodic maintenance.

This paper will describe the final maintenance database systems developed by Team A for Huffman Trucking Company. The database system chosen by Team A and the stakeholder was the Microsoft Access Database which allows the end users to have an easy access to their database in an effective way. Training will be provided to the end-users by one of the developer.

Maintenance Summary

The maintenance portion of the database consists of eleven tables: Maintenance Work Order, Maintenance Descriptions, Tire Maintenance, and Vehicle Maintenance. The Vehicle Maintenance table will be used to track vehicle maintenance. The table will consist of the following fields: "Vehicle Serial Number, Vehicle Part ID, Maintenance TypeID, Put In Service Date, Last Maintenance Date, Next Scheduled Maintenance Date, and Under Warranty Flag.

The Vehicle Serial Number will contain the unique vehicle VIN number." This will allow the Vehicles table to be linked to the Vehicle Types table. The Vehicle Part ID will contain the unique identifying information for the part being used in maintenance. This field will link to the Parts Catalogue which will describe the part. The Maintenance TypeID will be a unique ID for the type of maintenance being performed. This field will link to the Maintenance Descriptions table for a description of the type of repair being done. The Put Into Service and Last Maintenance Date fields contain the date the vehicle was put into service and when the vehicle was last maintained. The Next Scheduled Maintenance Date will contain the next ideal scheduled maintenance date. The final field, Under Warranty Flag will show if the vehicle is under warranty or not.

The Maintenance Descriptions table will consist of the following fields: "Maintenance Type ID, Level Code, Description, Average Hours Required, Days Between Recommended Maintenance, and Maximum Days Between Maintenance." This table will be used to describe the level and type of Maintenance that can be performed on a vehicle. The Maintenance TypID field will be unique id for identifying the type of maintenance being performed on a vehicle. The Level Code field will contain a unique value given to each maintenance type. The description filed will describe the maintenance being performed. The average Hours Required field will contain the amount of time require to perform a particular maintenance type. The Days Between Recommended