This page includes links to the different case studies that are part of the COP4834 Web Systems II class. Some of these may be useful, some may not. Either way – they are documented here.
Case Study: A Self Serializing Object Architecture
Language: C#
https://roneaglin.online/COP4834/case-studies/case-study-beyond-nosql-self-saving-object-architecture/ – I created an object management system in C# that serialized objects for storage into a single database table and field (or a file). I still use this architecture. It is complex to incorporate, but amazingly useful.
Case Study: Category and Code Management
Language: C#, SQL
https://roneaglin.online/COP4834/case-studies/case-study-category-codes/ – Categories and codes are used all through programming. This system shows how to code and manage a category code system. (Example category: states, Example codes: FL, GA, TX, …)
Case Study: Restaurant Menu Management System
Language: C#, SQL
https://roneaglin.online/COP4834/lectures/lecture-case-study-menu-example/ – This case study demonstrates SQL and C# and how to build a complete system to manage restaurant menus.
Case Study: Advanced Query using the Medicare Database
Language: SQL
https://roneaglin.online/COP4834/case-studies/case-study-medicare-database/ – This is a SQL example with solutions of import and query of an external database.
Case Study: A Math Quiz Web Site – My Daily Math
Language: SQL, C#
https://roneaglin.online/COP4834/case-studies/case-study-my-daily-math/ – Just an overview with links to code for the case study