Case Study - Registration Database


Case Study - Registration Database

 

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.

 

Video Lectures

 

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

 

Assignments

 

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

 

Submissions

 

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

 

Course Registration.mp4

Spring 2012 COP 4709 Final_Assignment_Juan_Zabala.docx