Autoparts Sales & Inventory Management Data Model

3 Pages 742 Words

Abstract / Introduction:

The selling of automotive aftermarket replacement parts is both a retail enterprise selling
to consumers and a wholesale operation selling parts to repair shops and other resellers.
In consideration of the diverse customer base, this data model will be developed so that sales of auto parts either retail or wholesale can be recorded and tracked electronically.
In addition, stock inventory levels will be monitored electronically with this model and an automated stock replenishment mechanism implemented.
Due to time constraints this model will be a stripped down version only pertaining to the
sales and inventory functions. The current design does allow for further development and the addition of other components.

Since the heart of an auto parts store is in its inventory of parts we will begin with an
explanation of how the inventory is managed. By the use of the MinQuantity field in the
Inventory table the system will be able to indicate a low stock level once the quantity in
stock is equal to or less than the minimum quantity specified by the MinQuantity attribute. At this point a View for Inventory can be generated to display inventory items whose quantity levels are below their specified minimum. This Reorder_View can be used by the system to generate purchase orders to vendors whose contact data and address are stored in the table named ‘Vendor’. Just as the Inventory table contains all the attributes for any given part the Vendor tabled does the same for all vendors.

To complete the description of the model that will be created we will now discuss the sales tracking process. Once a sale is made, a record of that sale is recorded in the
Daily_Sales table. A transaction number to be associated with this sale will be generated then used as part of the identifier for this sale. The store number and part number are also part of this unique identifier. From this record a sales invoice/r...