Service Request SR-ht-003 Database Report
Team B
Date

Service Request SR-ht-003 Database Report Smith Systems Consulting provides this report for the Huffman Trucking Company. The report contains detailed information on a database design for Huffman Trucking along with an Entity Relationship Diagram, which provides details regarding entities and attributes of the database as requested by Huffman Trucking. The DOT Inspection Table consists of the Inspection ID, Vehicle ID, Mileage, Inspection Date, Inspection Status, Failure Reason, and Comments. The DOT Inspection is in third normal form. This table holds information whenever a vehicle goes in for an inspection. All of the determinants are to candidate keys. The only determinants in this table are candidate keys. The Maintenance Work Order Table consists of Vehicle ID, Mileage, Inspection Date, Inspection Status, Failure Reason, and Comments. The Maintenance Work Order table is in the third normal form. It holds information on the actual maintenance performed and what type was performed. It also has a part list that describes what parts are used during the maintenance. The only determinants in this table are candidate keys. Parts Items Table consists of Part ID, Part Name, Part Description, and Comments. The part items table is in third normal form. This table holds information on the individual parts. This includes the name, description and the part id associated with it. The only determinants in this table are candidate keys. The Parts Inventory table consists of Part Number, Bin Location, Current Stock, Restock Target, Lot Size, Cost, and Comments. The Parts inventory table is in second normal form. This table holds information on parts that are currently used by the maintenance department. An update to the Part ID will replicate throughout the