What is the high-level standard Sales, Purchasing, and Inventory ERP system at Super Sports?
Overview of Super Sports
Super Sports (SS) is a renowned sporting goods company based in Tempe, Arizona. Known for its exceptional services and unique products, SS is considered one of the best sporting goods stores in terms of customer satisfaction. As the company continues to expand, it has initiated a project to update its outdated database system.
Business Rules
Product/Inventory Cycle - SS offers a wide range of sporting goods in various categories such as tennis, swimming, golfing, and hiking. Each product is assigned a unique Stock Keeping Unit (SKU) number, description, category, and unit price. Categories are identified by CatID, CatDesc, PromoCode, and AccountCode. All products at SS have been ordered from the vendor at least once, even if not all have been sold to customers and may eventually be removed from inventory.
What entities are involved in defining the Sales, Purchasing, and Inventory ERP system for Super Sports? The main entities in the Sales, Purchasing, and Inventory ERP system for Super Sports include Product, Category, Vendor, and Customer. Each entity has specific attributes that define their relationships within the system.