Generic Work

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.

Creator

• Nicholson, Bill

License

• All rights reserved

Submitter

Bill Nicholson

College

• Clermont College

Department

• Computer Programs

Relationships

Items

Thumbnail	Title	Date Uploaded	Visibility	Actions
	The Visual Studio Project that simulates transactions and adds records to the database	02/06/2017	Open Access
	SQL Server scripts to create the database, add the schema, and populate the tables	02/06/2017	Open Access