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.
The Essay on Huffman Trucking
Huffman Trucking is a large organization that provides transportation of goods and services to its customers. In order to better serve these customers and to compete and stay at a high level above other suppliers, Huffman Trucking management enlisted the assistance of Team B to upgrade their companies systems to be able to create, maintain, and report on a database, which tracks the servicing of ...
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.
The Essay on Huffman Trucking Ratio Analysis
Listed below you will find the findings from the current and quick ratios calculations. Huffman trucking’s current ratio within the liquidity ratio during 2 years indicates an increase. The Quick ratio within the liquidity ratio also indicates an increase. Since prospective lenders want to see a positive current ratio, they would be a type of user that would be interested in this type of ratio. ...
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.