Huffman Trucking Fleet Maintenance Database Solution
In this review, we will look at how to complete the service request to develop entity-relationship diagrams for Fleet Truck Maintenance at Huffman Trucking. The referenced ERD will enhance Huffman Trucking decision to developing a fully functional database for their fleet truck maintenance program. Smith Consulting has already developed the entities and attributes that will be using in the entity-relationship diagrams to help develop a database that can streamline Huffman Trucking’s fleet truck maintenance.
This new ERD for Huffman Trucking will take into account all parts of the maintenance program from parts to vendors to the different kinds of maintenance that is being performed on the vehicle. Keeping track of what has been ordered for parts will help plan for future budgeting. Tracking vehicle maintenance will help plan for timely vehicle replacement and repairs and work order tracking will help plan workloads and number of employees needed on a seasonal basis. The ERD design will help create a database that has the potential to reduce costs for the complete upkeep of their trucking fleet.
Current Mission and Goals
As with any data design project, many business rules and impacts will have to be considered. The vehicle maintenance nature of this system will require keeping inventory, which will reflect the status of parts available for maintaining the fleet’s vehicles. Scheduling maintenance for the fleet of vehicles also becomes important in ensuring that the fleet is properly maintained. Regular maintenance is critical in extending the useful life of the vehicles to maximize the return on capital investment. Fleet maintenance is essential; maintenance becomes foundational that Huffman Trucking has sufficient parts in inventory as not to defer maintenance while parts are being acquired. A well-designed maintenance system will ensure that inventory is sufficient for upcoming nominal maintenance,...