PartsInventoryIssue PartsInventoryPurchase PK Transction ID Purchase Date Purchase Price Quantity PK Transaction ID Issue Date Purchase Price Quantity Transction ID PK

PARTS CATALOGUE ID Description Type Manufacturer Quantity On Hand Reorder Point Reorder Quantity Transaction ID VENDORS PK PK,FK1 PK,FK2 PK,FK2 PK,FK2 Vendor ID ID Transaction ID Catalogue ID Manufacturer ID Name Order Address Order Contact Order Phone Number Order Fax Number Billing Address Billing Contact Billing Phone Number Billing Fax Number Tire Maintenance PK PK PK,FK1 Barcode Manufacturer ID Vehicle Serial Number

FK1

FK1

VEHICLE MAINTENANCE Parts Purchasing History PK PK PK Transaction ID Catalogue ID Manufacturer ID Quantity Purchased Order Quantity Price Shipping Tax FOB PK PK PK Vehicle Serial Number Vehicle Part ID Maintenance Type ID Put in Service Date Last Maintenance Date Next Scheduled Maintenance Date Under Warranty Flag Transaction ID Catalogue ID Manufacturer ID

FK1 FK1 FK1

MAINTENANCE DESCRIPTIONS PK PK,FK1 PK,FK1 PK,FK1 Maintenance Type ID Manufacturer ID Barcode Vehicle Serial Number Level Code Description Average Hours Required Days Between Recommended Maintenance Maximum Days Between Maintenance PK PK,FK1 PK,FK1 PK,FK1 PK,FK1

Type Vehicle Type Put in Service Date Rotation Schedule Last Rotated VEHICLE TYPES VEHICLES Disposal Date Type ID FK1 Vehicle Part ID Maintenance TypeFK1 PK,FK1 Maintenance Type ID ID Maintenance Type ID PK,FK1 Vehicle Serial Number Barcode Vehicle Serial Number PK,FK1 Manufacturer ID PK,FK1 Barcode Manufacturer ID PK,FK1 Type ID Description VIN Class Code Put into service Date Gross Weight Mileage Purchase Price Accumulated Depreciation Taken out of service Date Capacity

MAINTENANCE WORK ORDER PK PK PK,FK1 Work Order ID Part ID Maintenance Type ID Vehicle Assignment TO Date Started Date Completed Hours Type ID Vehicle Serial Number Manufacturer ID Barcode

FK1 FK1 FK1 FK1