OOP as Abstract Data Type

Practice SQL, use OOP, Have fun!

1. Put the MusicsRelationships database somewhere you know the location
2. Copy and paste the MusicOOPdb code from Pastebin http://pastebin.com/TQah82dH
3. step through the code and ensure you understand what’s happening
4. Create a new class called CD’s
   1. Add 3 properties, getters and setters
   2. Write a method to collect all the Cd’s from the Database
   3. Display the list in the console
   4. Write a method that returns a list of all the Artists that have made albums with more than 12 tracks 
   5. Write a method that returns all the Artists who are described as being "Pop"
   6. Add a new Artist (i.e Blur) Make sure you do it through the class and then through a new method that runs an insert query
   7. Add a new Album (i.e Parklife)  use a class and insert
   8. Use an Update query to change the Genre for "james blunt" from "pop" to "pants"