Autoparts_Sales_&_Inventory_Management_Data_Model

Autoparts Sales & Inventory Management Data Model 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 inventory, transaction, number, sales, new, model, table, insert, data, daily_sales, store, created, value, record, quantity, parts, part, items, wholesale, trigger, stock, sequence, sale, retail, information, generated, customer, trans, system, selling, recorded, process, implemented, identifier, end