Huffman Trucking Database

The operation record of Hoffman Freight Database is divided into 11 tables. The database uses the third paradigm or the Boyce Codd standard form (BCNF) (Pratt & Adamski, 2005, p. 153). This level of normalization eliminates duplicate groups, the key columns depend only on part of the primary key, and the only determinant of inclusion is the candidate key. The company has four offices in the United States and has 925 drivers. Due to the relatively small database, the number of daily updates normalized to the third normal form and the nature of the information are sufficient.

Hofmann Cargo requires a standardized database to properly maintain the records of each vehicle in the vehicle and the parts necessary to maintain them. The planned maintenance record and repair of each vehicle must keep a record. This information is important not only for safety and administrative reasons but for insurance purposes as well, for Hoffman's trucking. Run the maintenance schedule in the database using the current query and report. Another advantage is that you can generate ad hoc reports and queries that provide cost analysis and allow Hoffman to calculate costs more efficiently. The Hoffman Freight Database Runtime System can query the information requested by the company at any time to produce a report to plan for future or future costs.

For the purposes of this article, Team B made several assumptions. 1) Huffman Trucking Inc. implements the Microsoft Access Fleet Truck maintenance database as described on the Huffman Trucking internal website; 2) other departments within Huffman Trucking have separate databases that are not Access Database software, 3) needs to access multiple types of applications of the DBMS, 4) there are many concurrent users

We will explore the relationship of Hoffman truck transport fleet maintenance entity in MS Access and the possibilities to help extend and develop normalized database. Smith Consulting developed entities and attributes of Fleet Truck Maintenance, but did not develop a database. MASM designs a standardized database. Hoffman truck transport faces two operational feasibility issues. One is that technology can transform companies into more streamlined processes. According to the MASM survey, many logistics companies are already working in a high-tech environment and it was concluded that this is possible. The second problem is that customers need to support the expansion of the US region that Hoffmann currently does not cover. The technical problem we need to solve is whether Huffman can benefit from off-the-shelf packages, or if you need a custom application.