The Registration Database Case Study is a full creation of a student registration system with students, classes, semesters, course offerings, and students registering for classes. It demonstrates full creation of the database and also the use of .NET and Visual Studio to create a front-end for the database.
These video segments all use the Registration Database as a basis for the material in them.
Lecture - Foreign Keys Example 1
Lecture - Foreign Keys Example 2
Views Example using Registration System
Getting Started with Report Builder 3
Lecture - Complex Queries with Registration System
Lecture - Using a DropdownList with a Database
Lecture - Complex Queries with Registration System
These are all assignments that use the Registration Database Case Study.
Spring 2012 Assignment 4 - Starting with Stored Procedures
Spring 2012 Assignment 4 - Instructor Solution
Spring 2012 Assignment 6 - Creating a Report
Spring 2012 Assignment 8 - Completing the Registration System
Spring 2012 Assignment 10 - Putting it All Together
I do not normally put student submissions from assignments up with the case study, but i also don't usually get ones that have soundtracks - so here is one for enjoyment. I also included a second to demonstrate the different approaches taken by different students.
COP4709_Assignment10_Video_Jason_Schmidt.wmv
Spring 2012 COP 4709 Final_Assignment_Juan_Zabala.docx