Things to achieve

Here is the first cut of the things I want to achieve. The database will store CD details. I want to:

1. create a tablespace
   
2. create a database
3. create a user to own the database
4. create a role for the user to be in
5. create a table for publisher
6. create a table for artist
7. create a table for CDs, referential integrity against artist and publisher
8. create a table for tracks, referential integrity against CD
9. create a read-only user
10. write backup scripts for the database
11. ensure that deleting a CD deletes all tracks
12. ensure that deleting an artist deletes all CDs and tracks
13. write a report to report in number of CDs owned by artist
14. create data load scripts for publisher, artist and CDs