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
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
Fleet Truck Maintenance Database for Huffman Trucking Entities and Attributes Summary When using a database‚ the most important step is knowing how to use the table elements. The table defines the structure of the database based on its entities and Attributes. The entity is the object being stored and the Attributes describe information about the entity and its reason being documented. When using this table‚ one needs to first know how to access the database‚ table and
Premium Entity-relationship model Relationship Database
the Huffman Trucking Maintenance Department‚ Smith Consulting developed entities and attributes for their Fleet Trucking Maintenance database. Unfortunately‚ the creator of the database was not available and the development of the database system was not able to be completed. D Team realizes that the development of a reliable database system is needed to provide for the tracking of scheduled and unscheduled maintenance for their fleet. Therefore‚ a database along with forms‚ tables‚ queries‚ and
Premium Entity-relationship model Database Database normalization
Fleet Truck Maintainenace 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
Premium Relational model Microsoft Access Relation
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 James Roswell University of Phoenix BSA/310 Instructor: Eric Wilson November 11‚ 2010 Introduction Huffman Trucking Company was created in 1936 with a single tractor-trailer. There growth is due to World War II and the U.S. Governments demand for carrier services for factories in the Midwest to ports on the East Coast. In 1945‚ there growth increased to 36 trailers and 16 tractors. There growth is due to internal sales with the acquiring of five Eastern regional carriers
Premium Cargo Transport Transaction processing
Huffman 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 information
Premium Computer network Tracking Customer service
Areas of Strategic Plan: Huffman Trucking MGT/488 - Strategic Business Management and Planning December 19‚ 2011 William Funderburk Introduction The business continuity plan outlines the processes required to ensure the continuance of business during and after a disaster. The idea is not just to be able to continue business uninterrupted. But to also reestablish the full functions of the business as quickly as possible. Huffman Trucking Strategic Outline Huffman Stakeholders: Everyone
Premium Management Strategic management
Huffman Trucking Information Systems Security Review and Upgrade Background and Statement of Need An increasing growth of the Huffman network infrastructure and architecture requires review of existing network security hardware and software/application resources. This review will help to determine requirements for new systems and possible upgrades to protect Huffman Information Systems from exploitation and ensure security features are in place to combat increasing threats to customer information
Premium Project management Security Information security