Huffman Trucking Database Essay - 752 Words

Huffman Trucking Database The driving log was broken up into 11 tables. The database is in the third normal form or Boyce Codd Normal Form (BCNF) (Pratt Adamski, 2005, p. 153). This level of normalization ensures no repeating groups, no key column is dependent on only a portion of the primary key, and the only determinants that are contained are candidate keys. The company has four locations in the United States and services 925 drivers. Normalization to the third normal form is sufficient due to the relatively small database, the number of daily updates and the nature of the information. The database is searchable, and due to the naming methodology, is platform independent. Care was taken to omit reserved words from the major†¦show more content†¦Name, phone, and addresses of each contact are the fiends for this table. The driver table contains fields concerning the driver only and has their home address, home state (linked with the state field), license number, home telephone and mobile telephone. The berth table contains fields concerning the times and dates when the driver was in the berth and not driving. The driver can enter multiple times in or out of the berth. A comments field was added to allow the driver to provide detailed information about the stop such as when the co driver drove while the driver was in the berth or slept overnight. The event number is linked with the driving log table. The driving table contains the co driver, event number (linked with berth log and duty cycle log), tractor (linked to the tractor table), trailer (linked to the trailer log) and comments to be entered by the driver concerning the trip fields. The duty cycle table has the event number (linked with the driving log) on duty and off duty times. The table allows the driver to enter multiple events for each trip indexed by the event number. The table also has a comments field that can be used by the driver to document events that occurred either while on or off-duty. The tractor table contains information about each tractor owned by Huffman trucking. The log contains information about the service date, when the truck was operational or non operational andShow MoreRelatedHuffman Trucking1019 Words   |  5 PagesHuffman Trucking Infrastructure Assessment Huffman Trucking is first major freight carrier that has managed to grow tremendously over the past few years (Huffman Trucking, 2008). The company has 925 drivers, 425 support personnel, 800 road tractors, and 2100 trailers. The organization offers various customers base and distribution capacity. The mission of Huffman Trucking is to increase the profit and become a growing, and adaptable company. Huffman Trucking plans to leverage the automated informationRead MoreFleet Truck Maintainenace Database Paper914 Words   |  4 PagesMaintainenace Database Paper Its mind numbing to reflect the amount of technical change that has taken place in only a short period of time. In this current age, innovation has opened doors to a wide capacity for data collection and management. An example is the amount of business use with Microsoft Access. Businesses have gained from Access’s technical capabilities by using it to offer a wide range of ways to add value and efficient to any facility. Today we use Access databases to organize theRead MoreHuffman Trucking Benefits Election System Risks1200 Words   |  5 PagesHuffman Trucking: Benefits Election System Security Lisa M. Gardner CMGT442: Information Systems Risk Management March 19, 2012 Craig McCormick Huffman Trucking: Benefits Election System Huffman Trucking Company has requested a new Benefits Election System to be implemented within the organization. The current benefit packages include medical, dental, and vision plans for employees. For the BenefitRead MoreHuffman Truckings Request for a New Benefits Election System1161 Words   |  5 PagesHuffman Trucking: Benefits Election System Huffman Trucking Company has requested a new Benefits Election System to be implemented within the organization. The current benefit packages include medical, dental, and vision plans for employees. For the Benefit Election System, employee information and the benefit package they choose are stored and managed on a database system. This can either be a hardcopy paper file or an electronic file. Regardless of the storage method, security measures needRead MoreSecurity Requirements Possible Risks1342 Words   |  6 PagesNelson CMGT/442 February, 25, 2013 James Summerlin Security Requirements and Possible Risks: Benefits Elections System Huffman Trucking, an established trucking company since 1936, has recently requested the implementation of a new Benefits Elections System to assist management in tracking and reporting the benefits of both union and non-union employees. A database system will be utilized to store critical data such as employee information, along with the benefit package of their choosingRead MoreHuffman Trucking Service Request Sr-Ht-003805 Words   |  4 Pagesdesign for a fleet truck maintenance database, located on the Huffman Trucking IT Service Requests site. This paper will talk about how our team completed the Change Request that was on the Huffman Trucking Service Request. First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationshipsRead MoreProposal: Sr-Ht-003 for Huffman Trucking3227 Words   |  13 PagesProposal: SR-ht-003 for Huffman Trucking Proposal: SR-ht-003 for Huffman Trucking Huffman Trucking s central maintenance facility in Cleveland, Ohio and presently has hubs in Los Angeles, California, St. Louis, Missouri, and Bayonne, New Jersey. To effectively manage their business, it is critical that Huffman Trucking can share information regarding vehicles maintenance with each of its hubs, including parts inventory and vendor data. Huffman Trucking needs a solution that would allow themRead MoreVirtual Organization Staffing Strategies Case Study - Huffman Trucking941 Words   |  4 Pagesorganizational growth combined with a higher than industry turnover rate approaching 20% have necessitated the need to increase recruiting, consider internal transfers, and creation of a talent strategy succession plan. The first strategy for Huffman Trucking is review and implementation of internal candidates for newly created positions. The employee intranet should contain a listing of all internal positions open within the organizations three offices. Internal postings should be very detailed inRead MoreHuffman Trucking Initial Risk Assessment1366 Words   |  6 PagesHuffman Trucking Initial Risk Assessment Introduction Huffman Trucking is a national transportation company based in Cleveland, Ohio. (UOP, 2009) The organization has 1,400 employees and 800 trucks on the road, with logistical hubs in California, New Jersey and Missouri. The company’s mission reads: â€Å"our mission is to be a profitable, growing, adaptive company in an intensively competitive logistical services benefit environment.† The focus of Huffman’s mission is on stockholders, customers, regulatoryRead MoreHuffman Trucking Essay1830 Words   |  8 PagesFounded in 1936 with a single tractor-trailer, Huffman Trucking (Huffman), a national transportation company, is located in Cleveland OH. Today, Huffman has over 1,400 employees, 800 tractors, expected revenue to surpass $600,000,000 and is still privately held. Huffman has hubs located in Los Angeles, CA, St. Louis, MO, Bayonne, NJ with the central maintenance facility located in Cleveland OH. Their working contracts are primarily with the US Government, a utomotive parts industry, electronic consumer