James Adams
DBM/350
Professor Troy Tuckett
March 11, 2013
Creating a Database Design for Fleet Truck Maintenance
The planning designing and creation of the Fleet Huffman Trucking Maintenance Database will identify attributes, tables and fields for all of the service categories for the Huffman maintenance fleet Trucking Company. This database will be developed and design according to the vehicle maintenance activity and repairs to keep vehicles save on the road and save money down the line on the up keep on the vehicles. The Huffman Company will use real time data information pertaining to all the work history activities in the fleet truck maintenance facility.
The tables and entities describe in the fleet truck maintenance database will identify each attributes and a map between relationships that’s in the database, where each components interact with each other in a Query and SQL format. The table below will identify realistic data demonstrating each entity and attributes, regarding the relationship that each table brings to the database functions with populated information to support the table and entity. Entity | Attributes | Vehicles- a table displaying the vehicles in Huffman’s fleet. | * Vehicle_ID (PK) * VIN * Vehicle_detail * Put_inservice_date * Purchase_invoice * Taken_outservice_date | Vehicle_detail | * Veh_detail_ID (PK) * Vehicle_ID * Mileage * Type_ID * Capacity * Class_code * Gross_weight | Vehicle_Invoices- a table displaying invoices for all vehicles purchased. | * Veh_Invoice_ID (PK) * Vehicle_ID * Date_Purchased * Price * Shipping * Tax * FOB | Vehicle_Type- a table displaying the types of vehicles. | * Type_ID (PK) * Description | Maintenance_Descriptions- a table with general details of each maintnenace type | * Maintenance_Type_ID (PK) * Level_code * Description * Avg hours_req
References: Reference University of Phoenix (2007) Microsoft® (2011). Microsoft Access 2007 Retrieved August 11, 2011 from http://office.microsoft.com/en-us/training/CR010158283.aspx