Huffman Trucking: Database Implementation.

Introduction

Huffman truckage, a Cleveland, Ohio logistics firm that recently acquired five regional carriers (Huffman trucking, 2005) contract American Success Consulting (ASC) to develop an enterprise-level information system solution to enable the company to meet established business goals. ASC is beginning this effort by conducting an investigation and feasibility study for building a relational database. In this study we will reference book the scope of the redact, Huffmans business goals and assumptions. We will then present our findings concerning the projects technical, operational, and stinting feasibility. We will similarly include a diagram of the accredited business process and list the system requirements we propose.

Statement of Scope.

In exploring possibilities to help Huffman transport expand and develop Entity-Relationship Diagrams for Fleet Truck Maintenance and a Normalized Database in MS Access. Smith Consulting developed entities and attributes for Fleet Truck Maintenance but did not develop the database. MASM will forge the normalized database.

Business Goals.

Huffman Trucking wishes to reduce operations cost piece of music also expanding their market and remaining competitive. Our solution will meet these goals when implemented. We project Huffman Trucking will reduce operating costs 10-20% while increasing the companys market sh be.

Assumptions

In developing this investigation and feasibility proclaim MASM made the following assumptions:

- Huffman trucks often go over the charge mileage which requires trucks to be driven to the maintenance facility without a shipment which results in loss of profits

- Huffman operates a maintenance class at the Cleveland headquarters

- Tracking of trucks and shipment are done manually

- 800 trucks are processed at maintenance every 10 weeks

Project Feasibility

Huffman Trucking faces two operational feasibility issues. The first is if transforming the company to a more streamlined process through technology is possible. MASM seek has concluded that this is possible as many logistics businesses already operate...

If you deficiency to get a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper