Huffman Trucking Change Request 3

Topics: Entity-relationship model, Relation, Relational model Pages: 3 (699 words) Published: February 1, 2013
Service Request SR-ht-003
University of Phoenix
Team A
January 9, 2013
Ms. Sabella Falls

Service Request SR-ht-003 Change Request 3
Huffman Trucking is a large company and has been around since the early 1900’s. When the company started there was one tractor trailer and now the corporation has seen quite an extensive progression throughout the years. With several types of trailers and large employee base the company has spread out and has facilities located all across the country from New Jersey to California. Huffman Trucking Company consulted with another company known as Smith Systems Consulting to develop entities and attributes for a database for the fleet truck maintenance, but was unable to complete the job successfully.

A dependable database is required to provide tracking of the scheduled and unscheduled maintenance for their fleet. The development will contain a database with forms, tables, queries, and reports which track maintenance records, inventory of parts, and any purchases from vendors. The entity relationship diagram (ERD) project will reduce down time of each truck in the fleet and guarantee parts availability. The project will also minimize profits loss due to accessibility of trucks, and each hub will be able to access this database. The overall objective is to bring that proposed database to life and allow Huffman Trucking Company to use that database across all of their various locations.

Smith Systems Consulting designed and developed exclusive documents for Huffman Trucking Company using the entities and attributes created by Microsoft Access. The forms were created to simplify the entry of records into the database and will streamline the method of entering the parts information, vendor information, vehicle and vehicle maintenance information, and all supplementary associated entities to the Huffman Trucking Project. It is significant the Huffman Trucking Company vehicle upkeep relational database be...

References: Retrieved from:
Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Boston, MA: Course Technology.
Retrieved from: Trucking
Kroenke, D., & Auer, D. (2011). Database concepts, fifth edition. Pearson Education.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Huffman Trucking Essay
  • Service Request Dba/380 Huffman Trucking Research Paper
  • Huffman Trucking: Database Design and Development Essay
  • Essay on Huffman Trucking Entity-Relationship Model
  • Huffman Trucking Essay
  • Essay on Huffman Trucking
  • Proposal: Sr-Ht-003 for Huffman Trucking Essay
  • Huffman Trucking Network Systems Essay

Become a StudyMode Member

Sign Up - It's Free