HUFFMAN TRUCKING COMPANY, DATABASE DESIGN
Huffman Trucking Company, Explanation of the A Team Database Design
DBM/380 Database Concepts
University of Phoenix
Prof H. Heifets
July 7, 2009
Huffman Database Design 2
Huffman Trucking Company Background
The concept of a database design gives a thriving company a means of efficiency in organizing their vision to function in the most productive manner for the company to function.
Huffman trucking has grown from the start of a single tractor trailer into a successful company that now has 800 road tractors, 2100 forty-five foot trailers, and 260 inch roll on and roll off units. The success of the initial growth of the company is attributed to World War II and the high demands for services between Midwestern factories to the East Coast ports. Today the U.S Government is still one of Huffman’s primary customers. Amongst the government, other customers include: Auto parts suppliers to major manufacturers, Raw materials for manufacturers of plastic products and servicing those consumers that needs specific accommodations such as transporting wines, munitions, computers, and such.
Huffman has facilities in four states: Ohio, which is the originating base of the organization, California, Missouri and New Jersey. This is a company that has been recognized as the first major freight carrier to outsource 100% of its information systems support.
Explanation of Database Tables
Team A has created 13 tables to bring order to the functions of the thriving Huffman trucking company’s database. The database tables consist of primary keys, which are defined as fields or combinations of fields that uniquely identify a record so that it can be located without...