Week+8

= Midterm =

== **Starting Date: 03/04/13** ==


 * Agenda: (For each each bullet point in the agenda, there is a section below on this page with materials for you to read or otherwise interact with)**


 * Midterm Part 1 Take Home (start in class)
 * Midterm Part 2 Thursday in class
 * Final Project details posted Decide what your project will be: Due final week of the semester

== What You Should Do This Week ==
 * Midterm
 * Pick a final project

Take Home Part of Midterm: 75 points Must be turned in no later than Saturday 3/9/13

Personal CD Collection: Before iTunes, and other music databases existed, people used alternative ways to keep up with their music collection. As hard as it may seem, there are quite a few people that don't use iTunes and keep their music in a spreadsheet.

What you need to do:

Create a mini music database to keep track of a music CD collection.

Must have an E-R diagram

Must have a minimum of 5 tables (Can be more)

Must have a minimum of 8 records for each table.

Must have a minimum of 5 queries (Explain what the queries are and why they would be important to the user)

Create a SQL script that will create the database and populate records into the database

Turn in the SQL commands to create the queries and the explanation of using the queries.