Introduction Huffman Trucking is in need of a system to help maintain its large trucking fleet’s maintenance‚ purchases‚ and vehicles. What is being purposed is a relational database that will greatly improve the record keeping for its fleet. This system will allow for reports to be generated to ensure that all vehicles have been properly maintained and record the daily operations of the maintenance department. The types of reports that can be generated are: * Parts Inventory Purchase
Premium Vehicle Type system SQL
Huffman Trucking GPS Tracking System BSA/310 August 20th‚ 2011 Huffman Trucking GPS Tracking System Background Huffman Trucking has mobile assets that include 800 road tractors‚ over 2100 trailers‚ and 260 roll-on/roll-off units. Huffman employees 925 drives and 425 support staff across several states. The lifeblood and backbone of Huffman is the efficient and timely pickup/delivery of goods‚ and keeping their trucks rolling on the road fully loaded for the outbound/return leg of the trip
Premium Vehicle tracking system Customer service Customer
Huffman Trucking Data Warehouse Jason Raines DBM/502 06/26/2014 Anup Majumder Huffman Trucking Data Warehouse Huffman trucking was founded by K Huffman in 1936 with a single tractor trailer. The massive and fast growth of the company was a direct result of WWII because of the increase in carrier services east to west. “By 1945‚ the fleet had increased in size to 16 tractors and 36 trailers. The business relationship forged with the U.S. Government continues today” (Apollo Group‚ 2012).This growth
Premium Data warehouse Database management system Data mining
As pointed out previously‚ Huffman Trucking has experienced tremendous growth over the past few years. Our huge trucking fleet and large number of employees exceed the usual numbers for a privately held trucking company. The growth of our company has become so significant that we must now face the issue of expanding our business. Even though our expansion can be done in many ways‚ our financial team has narrowed down our expansion options to becoming a publicly shared company (through an IPO)‚ acquiring
Premium Economics Marketing Mergers and acquisitions
Service Request SR-ht-003 TechTarget says “Computer databases typically contain aggregations of data records or files‚ such as sales transactions‚ product catalogs and inventories‚ and customer profiles” (TechTarget pg. 1). This is exactly what Team A plans to accomplish for Huffman Trucking. Huffman Trucking is looking for fleet truck maintenance database to help keep track of all of their truck maintenance needs. The database began on April 1‚ 2013 and has a scheduled completion date on April
Premium Vehicle Automobile Manufacturing
Running head: HUFFMAN TRUCKING Huffman Trucking: Database Design and Development Huffman Trucking started out as a single owner‚ single truck and trailer‚ operating in the Cleveland Ohio area back in 1936 doing local contract hauls. Today‚ Huffman Trucking is a National carrier with 1‚400 employees‚ 800 tractors‚ 2‚100 trailers‚ and 260 roll-on/roll-off units‚ operating from 3 logistical hubs located in Los Angeles‚ California‚ St. Louis‚ Missouri‚ and Bayonne‚ New Jersey
Premium Relational model Database
Huffman Trucking Huffman Trucking‚ a major national freight carrier has encountered tremendous growth over the past few years. The company now has over 1300 employees‚ 800 road tractors and 2100 trailers. The company has a diverse customer base and shipping ability. Management has realized that the company’s automated information systems infrastructure is lagging. To solve this problem management has decided to implement an Enterprise Resource Planning (ERP) system. Customer sales‚ orders‚
Premium Vehicle tracking system Information system Information systems discipline
The Huffman Trucking Company was founded in 1936 with only one tractor-trailer. The Company grew because of World War II; it boosted the need for carrier services between factories in the Midwest to ports on the East Coast. In 1945‚ the business had grown in size to 16 tractors and 36 trailers. They still have a business with the U.S. Government today. Huffman Tucking Company has been acknowledged as the first major freight carrier to subcontract 100% of its information systems support. The business
Premium United States Marketing World War II
Sustaining Employee Performance HRM 300 Sustaining Employee Performance Huffman Trucking is constantly re-evaluations its employee policies and always looking for better ways to serve employees and customers alike. Re-evaluating key positions within the company such as the Operational Analyst‚ and Truck Driver positions in order to sustain employee performance in these areas‚ are just some examples on how the company constantly strives to continue to be successful now and in the future. The following
Premium Management Employment Organization
Service Request SR-ht-003 Documentation DBA 380 April 30‚ 2012 Kurt Jost 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
Premium Database normalization Entity-relationship model