Service Request Dba/380 Huffman Trucking

Topics: Database normalization, Entity-relationship model, First normal form Pages: 2 (553 words) Published: June 4, 2012
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 maintenance of the 800 road tractors currently in operation.

Create Fleet Truck Maintenance Database (CR2)
To provide Huffman trucking with a comprehensive database the design team will first develop the requirements. During the requirements stage the team will conduct interviews with all the stakeholders as well as gather sample forms, reports, queries, and descriptions of all activities involved with the fleet maintenance process. The second portion of the requirements stage is for the team to create prototypes and working demonstrations of the proposed solution. These prototypes will be used to obtain additional feedback from the stakeholders and create the fine tune the database requirements (Kroenke & Auer, , 2010).

Link Fleet Truck Maintenance Databases (CR3)
The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.

Create Fleet Truck Maintenance Database Forms (CR4)
Team D ensures the process of normalization in the...

References: Apollo Group. (2003, 2004, 2012). Huffman trucking. Retrieved from /secure/aapd/CIST/VOP/Business/Huffman/intranet/it/databases.asp
Kroenke, D. M., & Auer, D. J. (2010). Database Concepts (4th ed.). Retrieved from
Oppel, A. J. (2004). Databases Demystified. Emeryville, CA: McGraw-Hill/Osborne.
Teorey, Toby J. & Lightstone, Sams S & Nadeau, Tom & Jagadish, H.V. (2011). Database modeling and design: logical design (5th ed.)
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Huffman Trucking Change Request 3 Essay
  • Team A Service Request WK4 V2 Essay
  • house hold Service request Essay
  • Huffman Trucking Essay
  • Huffman Trucking: Database Design and Development Essay
  • Essay on Huffman Trucking Entity-Relationship Model
  • Huffman Trucking Essay
  • Essay on Huffman Trucking

Become a StudyMode Member

Sign Up - It's Free