This project includes a SQL Server database and a Visual Studio project that simulate the transactions at a chain of grocery stores. It has stores, employees, products, ingredients in the products, manufacturers, and brands. When the simulation runs it generates customer transactions, employee work history, store history (open/closed/on fire/etc.), coupons, coupon usage, and product price history. As this data accumulates you can use it to teach SQL programming and query design.
The source code for the simulation project is included and can be used as an object lesson for software development courses, particularly C# and OOP.
