Index Catalog // Scholar@UC

Type:: Dataset
Description/Abstract:: SQL Server scripts to create the database, add the schema, and populate the tables.
Creator/Author:: Nicholson, Bill
Submitter:: Bill Nicholson
Date Uploaded:: 02/06/2017
Date Modified:: 02/06/2017
License:: Attribution-NonCommercial-ShareAlike 4.0 International

Type:: Document
Description/Abstract:: A VS Project written in C#. Includes data manipulation, OOP, Database connections, and simulation logic.
Creator/Author:: Nicholson, Bill
Submitter:: Bill Nicholson
Date Uploaded:: 02/06/2017
Date Modified:: 02/06/2017
License:: Attribution-NonCommercial-ShareAlike 4.0 International

Type:: Generic Work
Description/Abstract:: 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/Author:: Nicholson, Bill
Submitter:: Bill Nicholson
Date Uploaded:: 10/27/2017
Date Modified:: 10/27/2017

Search Constraints