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
Proposal: 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 them
Premium Entity-relationship model Unified Modeling Language
Corporate Characteristics Proposal Katherine Collinge‚ Moses Gatson‚ Tanya Mueller‚ and Terri Sturgeon University of Phoenix ACC/363 Financial Accounting II Bob Wells April 27‚ 2009 Corporate Characteristics Proposal Introduction here Various Forms of Business Organizations Before starting a new business‚ several decisions such as its legal structure must be made first. Five basic entity types exist in which to structure a business. These types consist of sole
Premium Corporation Limited liability company Types of companies
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
Huffman Trucking Income Statement / Vertical Analysis December 31st‚ 2006 | In Thousands$ | Percent of Net-Sales(Rounded) | | 2006 | 2005 | 2006 | 2005 | Revenues | 879‚944 | 807‚288 | 100% | 100 | | Operating Expenses | | Salaries‚ Wages & Benefits | 353‚739 | 330‚597 | 40% | 41% | Fuel Expense | 217‚363 | 192‚357 | 25% | 24% | Operating Supplies & Expenses | 152‚318 | 136‚319 | 17% | 17% | Purchased Transportation | 89‚957 | 82‚429 | 10% | 10% | Operating Taxes
Premium
The Entity-Relationship Model ------------------------------------------------- Top of Form Bottom of Form Database Design Goal of design is to generate a formal specification of the database schema Methodology: 1. Use E-R model to get a high-level graphical view of essential components of enterprise and how they are related 2. Then convert E-R diagram to SQL DDL‚ or whatever database model you are using E-R Model is not SQL based. It ’s not limited to any particular DBMS. It is a
Premium Entity-relationship model
Team A Ratio Analysis Memo Liquidity Ratios section Current Ratio A company must consider current ratios when determining the Liquidity ratios; this is because a current ratio is used to determine what the company liquidity and their ability to pay the companies short term debts back. The current ratios are figured out by talking the company’s current assists and dividing them by their current liabilities. In order to become a ratio it must be taken by x: 1‚ x is the current assets for every dollar
Premium Balance sheet Inventory Asset
Memo To: Kristen Huffman‚ President and CEO From: Maisha Morris‚ William Jefferson‚ Rebecca Reyes‚ George Taylor and Jason Thorn Date: September 25‚ 2012 Re: Huffman Trucking Ratio Analysis Team B has completed a ratio analysis on Huffman Trucking. Our team has looked over financial statements to determine the liquidity‚ profitability‚ and solvency ratios of Huffman Trucking. These ratios provide detailed information to creditors‚ investors‚ and employees. Together‚ the ratios reveal data related
Premium Financial ratio Balance sheet Finance
LTD Ratio Analysis Memo ACC 291 Memorandum Monday‚ March 4th‚ 2013 To: CEO‚ Riordan Manufacturing Inc. From: Financial Analyst LTD Listed below you will find a quick analysis of the company using productivity‚ Liquidity and solvency ratios. This analysis is accompanied by vertical and horizontal analysis. These analysis gives anyone inquiring a good picture of the company’s overall performance. This analysis is also a good way to determine the company’s financial standings for the said
Premium Balance sheet Generally Accepted Accounting Principles Asset
According to Service Request SR-ht-003‚ We were to develop a design 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
Premium