Huffman Trucking Erd Explanation
Huffman Trucking ERD Explanation
Alvin Calahan, Adam Morgan
University of Phoenix
Database Concepts
DBM/380
Michael James
November 19, 2011
Huffman Trucking ERD Explanation
Huffman Trucking, founded in 1936 with a single tractor trailer has grown tremendously over the years. Huffman Trucking now has 800 road trailers, 2100 45 ft. trailers, 260 roll-on and roll-off units, 925 drivers, and 425 support personnel. With facilities in Cleveland, OH, Los Angeles, CA, St. Louis, MO, and Bayonne, NJ, Huffman Trucking consulted with Smith Systems Consulting, who developed entities and attributes for the Fleet Truck Maintenance database, but did not develop the database. Therefore, Entity-Relationship Diagrams are needed in order to better document their applications.
The following document will detail how the Entity-Relationship Diagrams were developed and why they are necessary in the documentation of Huffman Trucking Fleet Truck Maintenance program. The document will further provide a detailed explanation on the different components of an ERD and how they relate data to one another. This document explains, that by using a software program such as Microsoft Access, the tables in the database were linked in a manner that shows the relationship amongst the different aspects of the database.
Entity-Relationship models were first published in 1976 by Peter Chen, which was in basic model form. Now, the basic model was extended to create the extended entity-relationship model, which is used extensively in today’s businesses. The E-R model used today consists of entities, attributes, identifiers, and relationships. These will be discussed in more detail to explain how they were used in creating the current database for Huffman Trucking.
As explained earlier in this document, the entities and attributes were already created by Smith’s Systems Consulting, but gave no details on how they would be used in the database. In order to fully explain how the entities and
Alvin Calahan, Adam Morgan
University of Phoenix
Database Concepts
DBM/380
Michael James
November 19, 2011
Huffman Trucking ERD Explanation
Huffman Trucking, founded in 1936 with a single tractor trailer has grown tremendously over the years. Huffman Trucking now has 800 road trailers, 2100 45 ft. trailers, 260 roll-on and roll-off units, 925 drivers, and 425 support personnel. With facilities in Cleveland, OH, Los Angeles, CA, St. Louis, MO, and Bayonne, NJ, Huffman Trucking consulted with Smith Systems Consulting, who developed entities and attributes for the Fleet Truck Maintenance database, but did not develop the database. Therefore, Entity-Relationship Diagrams are needed in order to better document their applications.
The following document will detail how the Entity-Relationship Diagrams were developed and why they are necessary in the documentation of Huffman Trucking Fleet Truck Maintenance program. The document will further provide a detailed explanation on the different components of an ERD and how they relate data to one another. This document explains, that by using a software program such as Microsoft Access, the tables in the database were linked in a manner that shows the relationship amongst the different aspects of the database.
Entity-Relationship models were first published in 1976 by Peter Chen, which was in basic model form. Now, the basic model was extended to create the extended entity-relationship model, which is used extensively in today’s businesses. The E-R model used today consists of entities, attributes, identifiers, and relationships. These will be discussed in more detail to explain how they were used in creating the current database for Huffman Trucking.
As explained earlier in this document, the entities and attributes were already created by Smith’s Systems Consulting, but gave no details on how they would be used in the database. In order to fully explain how the entities and