Entities And Attributes For Fleet Truck Maintenance

At the request of the Huffman Trucking Maintenance Department, Smith Consulting developed entities and attributes for their Fleet Trucking Maintenance database. Unfortunately, the creator of the database was not available and the development of the database system was not able to be completed. D Team realizes that the development of a reliable database system is needed to provide for the tracking of scheduled and unscheduled maintenance for their fleet. Therefore, a database along with forms, tables, queries, and reports that tracks information gathered by maintenance records, inventory of parts and purchases from vendors is proposed.

Huffman Trucking desires to advance and make certain that maintenance is performed and tracked for the entire fleet of trucks across all of the companies other locations. In an effort to better document our applications, Entity-Relationship Diagrams are needed. The expected results should convey and deliver the creation of Entity-Relationship Diagrams for Fleet Truck Maintenance.

The project will minimize down time for vehicles in their fleet by ensuring parts are on hand to perform the maintenance. Having these needs met with minimize potential revenue lost due to unavailable vehicles. The goal of the project is to create the entity relationship diagrams that will support the creation of a shared database that can be accessed by all of Huffman Trucking various locations.

The team is assuming that Smith Consulting accurately interpreted all of the entities. Secondly, it is being assumed that Huffman has the necessary infrastructure or the means to put into operation the appropriate infrastructure, hardware, software, and licensing. Therefore, assuming these components will not limit or influence the ERD. In a real life situation, one always has some working assumptions that one needs to document and clarify with the client.

In order to ensure a successful ERD, several tasks will need to be executed. One of the constraints we are presented with is the potential lack of documentation. One way to overcome this constraint will be to interview subject matter experts and the key players involved in the maintenance process. The first requirement will be to draft an Entity-Relationship Diagram (ERD) based upon the business rules and the entities, which were captured by Smith Consulting. All of Huffman’s hubs will use the database and with that, will need to be robust enough to handle the volume.