database and documentation paper
shaon_5
hoffmantrucking1.accdb
| Purchasing_ID | Parts_ID | Quantity_Purchased | Manufacturer_ID | Purchase_Price | Shipping_Price | Tax | Total_Purchase_price |
| Work_Order_ID | VIN | Part_ID | Maintenance_Type_ID | Assigned_to_Tech# | Date_Started | Date_Completed | Total_Hours_Charged_ to_Order |
| Part_ID | Part_Description | Part_Type | Part_Manufacturer | Quantity_on_Hand | Part_Reorder_Point | Part_Reorder_Quantity |
| Transaction_ID | Part_ID | Purchase_Date | Purchase_Price | Quantity |
| Transaction_ID | Part_ID | Issue_Date | Quantity |
| Tech# | Tech_FName | Tech_LName | Date_Hired |
| Tire_Barcode | Tire_Manufacturer_ID | Tire_Type | Installed _on_VIN | Install_Date | Rotation_Schedule | Last_Rotation_Date | Tire_Disposal_Date |
| VIN | Type_ID | Class_Code | Vehicle_In_Service_Date | Vehicle_Gross_Weight | Vehicle_Capacity | Vehicle_Mileage | Vehicle_Purchase_Price | Vehicle_Accumulated_Depreciation | Vehicle_Out_of Service_Date |
| Maintenance_Type_ID | Maintenance_Level_Code | Maintenance_Description | Average_Hours _Required | Days_Between_Recommended_Maintenance | Maximum_Days_Between_Maintenance | Part_ID |
| VIN# | Parts_Used | Maintenance_Type_ID | In_Service_Date | Last_Maintenance_Date | Next_Scheduled_Maintenence_Date | Maintenance_Covered_Under_Warranty |
| Vehicle_Type_ID | Vehicle_Description |
| Vendor_AddressList# | Vendor_Building_Number | Vendor_Building_Street | Vendor_Building_City | Vendor_Building_State | Vendor_Building_Zip |
| Vendor_Contact# | Vendor_Contact_FName | Vendor_Contact_LName | Vendor_Contact_Phone_Number | Vendor_Contact_Fax_Number |
| Vendor_ID | Vendor_Name | Vendor_Shipping_Address | Vendor_Contact | Vendor_Billing_Address | Vendor_Billing_Contact |
