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 maintenance of the 800 road tractors currently in operation. Create Fleet Truck Maintenance Database (CR2)
Premium Database normalization Entity-relationship model
Kirk Samuda‚ Dip. MIS‚ BSc. It‚ MBA Huffman Trucking Paper Kirk Samuda | Foley Belshaw Institute / Foley Belshaw University August 26‚ 2007 | | I observed while performing a detailed analysis of Huffman’s Trucking ERP‚ that various Operating Systems (OS) were used throughout the entire company. To understand the position of the company in choosing to keep all these OS‚ it is important that they are listed and described individually so as to outline their purpose and
Premium Microsoft Windows Operating system Microsoft
DATABASE SPECIFICATIONS Huffman Fleet Truck Maintenance Team A May‚ 2009 Revision Sheet Release No. Date Revision Description 1 5/2/09 Initial creation of document - Kramer 3 5/3/09 Addition of POC and Abbreviations - McCoy 4 5/4/09 Schema - section 2.5.1 DATABASE SPECIFICATIONS TABLE OF CONTENTS Page # 1.0 GENERAL INFORMATION 2 1.1 Purpose 2 1.2 Scope 2 1.3 System Overview 1 1.4 Project References 1 1.5 Acronyms and Abbreviations 1 1.6 Points of Contact
Premium Entity-relationship model
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 conceptual
Premium 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
on data or data items to supply some information about an entity. What is a Database? A database is an integrated and structured collection of stored operational data used (shared) by application systems of an enterprise Examples of Databases • Medical records • Bank accounts • Stock control • Telephone directories • Stock market prices Universe of Discourse A database is a model of some aspect of the reality of an organisation. It is conventional
Premium Data modeling Relational model SQL
1. Let us design a database for an bank‚ including information about customers and their accounts. Information about a customer includes their name‚ address‚ phone‚ and Social Security number. Accounts have numbers‚ types(e.g.‚ savings‚ checking) and balances. We also need to record the customer(s) who own an account. Draw the E/R diagram for this database. Be sure to include arrows where appropriate‚ to indicate the multiplicity of a relationship. Solution: [pic] 2. For your E/R diagram of
Premium Relational model Florida Keys Relation
1. MySQL is the world’s second most widely used open-source relational database management system (RDBMS). It is named after co-founder Michael HYPERLINK "http://en.wikipedia.org/wiki/Michael_Widenius"Widenius’s daughter‚ My. The SQL phrase stands for Structured Query Language. The default port of Mysql is 3306. The MySQL development project has made its source code available under the terms of the GNU General Public License‚ as well as under a variety of proprietary agreements. MySQL was owned
Premium SQL Database management system Database management systems
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 database system. While the creation of relationships
Premium
ITM540 – Database and Knowledge-base Management Module 3 Case Assignment 3 Robert T. Goodwin Database Applications In his book Groupware -- Computer Support for Business Teams‚ Robert Johansen defines groupware as "specialized computer aids that are designed for the use of collaborative work groups." This definition is better than the "shared data" definition because it helps eliminate multiuser databases from the groupware category
Premium Database SQL Collaboration