Huffman Trucking is a large company and has been around since the early 1900’s. When the company started there was one tractor trailer and now the corporation has seen quite an extensive progression throughout the years. With several types of trailers and large employee base the company has spread out and has facilities located all across the country from New Jersey to California. Huffman Trucking Company consulted with another company known as Smith Systems Consulting to develop entities and attributes for a database for the fleet truck maintenance, but was unable to complete the job successfully.
A dependable database is required to provide tracking of the scheduled and unscheduled maintenance for their fleet. The development will contain a database with forms, tables, queries, and reports which track maintenance records, inventory of parts, and any purchases from vendors. The entity relationship diagram (ERD) project will reduce down time of each truck in the fleet and guarantee parts availability. The project will also minimize profits loss due to accessibility of trucks, and each hub will be able to access this database. The overall objective is to bring that proposed database to life and allow Huffman Trucking Company to use that database across all of their various locations.
Smith Systems Consulting designed and developed exclusive documents for Huffman Trucking Company using the entities and attributes created by Microsoft Access. The forms were created to simplify the entry of records into the database and will streamline the method of entering the parts information, vendor information, vehicle and vehicle maintenance information, and all supplementary associated entities to the Huffman Trucking Project. It is significant the Huffman Trucking Company vehicle upkeep relational database be regularized to the highest degree probable.
Giving careful thought to the Entity-Relationship Diagram (ERD) that was created for this project, a normalized relational database can be created. The normalization procedure will remove any anomalies and redundancies creating a database that is well merged and designed. The normalization will verify to be cost-effective by lowering memory space distribution by eradicating repeating data. Database normalization will also successfully store the data, thus decreasing CPU usage each time data lookup or queries are to be done on the tables. Proper memory allocation and reduced CPU cycles will make Huffman Trucking Company’s vehicle
Huffman Trucking Company necessitates a normalized database to properly sustain a record of each of the vehicles in the fleet and of the parts required to maintain those vehicles. A record of the scheduled maintenance as well as any repairs made to each vehicle must be retained. This information is vital to Huffman Trucking not only for security and governing reasons but also for insurance purposes.
Maintenance arrangement handling occurs within the database using the current query and report. Another advantage is the ability to generate ad-hoc reports and queries that will deliver cost analysis and allow Hoffman to calculate costs more efficiently. Huffman Trucking database running system can query whatever information the company requests at any given time, to create reports to plan future or forthcoming expenses.
Specifically intended output reports have been designed for the Huffman Trucking development that will meet or exceed all insurance company compliance matters. Because of the previous creation of an ERD and the normalization of the database, each report will be pertinent and complete for its projected purposes. A maintenance history report will be created each time a vehicle requires scheduled maintenance. Additionally, part record and vendor reports will be created and can be produced at any time. Conception of reports also permits others besides database users to observe the information contained in the database and to evaluate it without the need to have database change access or understand the relationships structure.
Retrieved from: www.bignerds.com
Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Boston, MA: Course Technology. Retrieved from: https://ecampus.phoenix.edu/secure/aapd/cist/vop/ServiceRequests/index.asp#Huffman Trucking Kroenke, D., & Auer, D. (2011). Database concepts, fifth edition. Pearson Education.