Entities and Attributes for Fleet Truck Maintenance Essay

1953 Words Apr 5th, 2008 8 Pages
At the request of 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 reports that tracks information gathered by maintenance records, inventory of parts and purchases from vendors is proposed. Huffman Trucking desires to advance and make certain that maintenance is performed and tracked for …show more content…
Relational Database Rationale The entity relationship diagram our D Team has constructed is for a relational database. Relational databases are composed of multiple tables that contain both fields and attributes which share a specific relationship with one another. These relationships are sometimes referred to as parent-child relationships. The way it works is the primary key for one table will be used as the foreign key in a relating table thus accounting for the relationship. The table containing the primary key is known as the parent table and the opposite table housing the foreign key is the child table. Two other types of databases that we have discussed are flat file databases and data warehouses. A flat file database is made up of only one table which contains all the data gathered in separate fields on that one table. Flat file databases can be equated with spreadsheets like the type found in MS Excel. Formulas can be computed and reports can be generated, but data entry will be restricted to that one table. Like relational databases, warehouse database systems can be normalized; however, they are usually the result of a combination of several different databases holding enormous amounts of information. Warehouse database systems stores historical data used for analytical processing and is unchanging. This information is accessed through the use of an external operating

Related Documents