University of Phoenix
January 9, 2013
Ms. Sabella Falls
Service Request SR-ht-003 Change Request 3 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
References: 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.