Index Catalog // Scholar@UC

Type:: Dataset
Descripción/Resumen:: SQL Server scripts to create the database, add the schema, and populate the tables.
Creador/Autor:: Nicholson, Bill
Peticionario:: Bill Nicholson
Fecha modificada:: 02/06/2017
Fecha modificada:: 02/06/2017
Licencia:: Attribution-NonCommercial-ShareAlike 4.0 International

Type:: Document
Descripción/Resumen:: A VS Project written in C#. Includes data manipulation, OOP, Database connections, and simulation logic.
Creador/Autor:: Nicholson, Bill
Peticionario:: Bill Nicholson
Fecha modificada:: 02/06/2017
Fecha modificada:: 02/06/2017
Licencia:: Attribution-NonCommercial-ShareAlike 4.0 International

Type:: Generic Work
Descripción/Resumen:: 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.
Creador/Autor:: Nicholson, Bill
Peticionario:: Bill Nicholson
Fecha modificada:: 10/27/2017
Fecha modificada:: 10/27/2017

Buscar