Music Database

Case Study – Music Database

 

The Music Database case study was created as part of the assignments for COP4709 in the Spring 2013 semester. This page contains the scripts for this database for all tables and stored procedures and functions.

Related Assignments

 

COP4709 Spring 2013 Assignments

 

Assignment 1 – Creating the database Spring 2013 COP4709 Assignment 1

Assignment 3 – Stored Procedures used in Database Spring 2013 COP4709 Assignment 3

Assignment 4 – Stored Functions used in Database Spring 2013 COP4709 Assignment 4 – Solution: Spring 2013 COP4709 Assignment 4 Solution

Assignment 6 – Reporting Spring 2013 COP4709 Assignment 6

Assignment 7 – Reporting Spring 2013 COP4709 Assignment 7

Lectures

Lecture – Table Joins Part 1

Lecture – Report Builder Part 2

Table Scripts

 

Stored Procedures and Functions