Inventory Control and Pricing

The Products table stores details about the products available in the inventory. It includes essential information such as the product name, description, national maximum price, reorder level, and reorder quantity. This table is crucial for maintaining a national overview of product pricing and stock levels, ensuring that inventory is managed efficiently.

The Stores table records information about different store locations, including the store name, manager, staff details, and location and address. It serves as a directory for managing the various stores within the system, connecting them with specific products and staff members.

The Store Product Prices table connects products to individual stores, allowing for store-specific pricing and stock management. It tracks the store name, product name, product price, discounts, reorder levels, and reorder quantities, helping store managers adjust prices and ensure timely product restocking.

The Staff table provides a detailed record of store employees. It contains personal information such as the staff member’s name, job title, contact details, date of birth, and commission percentage. This table is essential for managing human resources, including tracking when staff members join or leave the company.

The Staff Sales table tracks the sales performance of individual staff members, including the sales date, value of sales, and the commission earned. This table is important for evaluating staff productivity and calculating sales commissions based on their performance.

This database provides an organized approach to inventory control, pricing management, and staff sales tracking, ensuring that all aspects of product and store management are effectively monitored.