- create a tablespace
- create a database
- create a user to own the database
- create a role for the user to be in
- create a table for publisher
- create a table for artist
- create a table for CDs, referential integrity against artist and publisher
- create a table for tracks, referential integrity against CD
- create a read-only user
- write backup scripts for the database
- ensure that deleting a CD deletes all tracks
- ensure that deleting an artist deletes all CDs and tracks
- write a report to report in number of CDs owned by artist
- create data load scripts for publisher, artist and CDs
- write forms to allow entry of publishers, artists, CD's and tracks
- write a form to list the tracks of a selected CD
- write a report to list all the CD's owned by an owner
Just somewhere to keep my notes while I'm playing.
Tuesday, May 5, 2009
A new direction - PHP and MySQL
I have decided to focus on the LAMP stack, primarily PHP rather than Perl at the moment, and MySQL rather than Postgresql.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment