Huffman++Truck+Maintenance (1)

Huffman++Truck+Maintenance (1) - Entities and Attributes...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Entities and Attributes for Fleet Truck Maintenance This document was created by Smith Systems Consulting at the request of Huffman Trucking Maintenance Department. The descriptions provided are based on interviews with maintenance personnel who use the Fleet Truck Maintenance database. The creator of the database was not available. PARTS INVENTORY Purchases This table represents truck maintenance parts that have been purchased. Transaction ID Purchase Date Purchase Price Quantity PARTS INVENTORY ISSUES This table represents parts that have been taken out of inventory. Transaction ID Issue Date Purchase Price Quantity PARTS CATALOGUE The data in this catalogue are all parts used in the truck maintenance operation of Huffman Trucking. ID Description Type Manufacturer Quantity On Hand Reorder Point Reorder Quantity VENDORS These are the approved vendors which can be used to supply parts to the Huffman Truck Maintenance operation.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Vendor ID Name Order address Street City State Zip Order Contact
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Huffman++Truck+Maintenance (1) - Entities and Attributes...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online