April 30, 2012
Service Request SR-ht-003 Documentation
Huffman Trucking Background
Huffman trucking is a national transportation company with 1,400 employees working in various logistical hubs located in Los Angeles, California, St. Louis, Missouri, and Bayonne, New Jersey. The central maintenance facility located in Cleveland, Ohio has an immediate requirement for a Fleet Truck Maintenance database to ensure the prompt and efficient maintenance of the 800 road tractors currently in operation.
Create Fleet Truck Maintenance Database (CR2)
To provide Huffman trucking with a comprehensive database the design team will first develop the requirements. During the requirements stage the team will conduct interviews with all the stakeholders as well as gather sample forms, reports, queries, and descriptions of all activities involved with the fleet maintenance process. The second portion of the requirements stage is for the team to create prototypes and working demonstrations of the proposed solution. These prototypes will be used to obtain additional feedback from the stakeholders and create the fine tune the database requirements (Kroenke & Auer, , 2010).
Link Fleet Truck Maintenance Databases (CR3)
The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.
Create Fleet Truck Maintenance Database Forms (CR4)
Team D ensures the process of normalization in the...