This is the last piece of coursework that I need to do for this degree. It’s relatively straightforward but does require lots of thinking. And lots of entering SQL commands 🙁 .
I could really do with a copy of phpPgAdmin on that server right now.
incidentally the PostgreSQL manual is quite good – it’s been quite easy to find some of the more advanced functions that I’ve needed, such as defining table inheritance and specifying foreign keys.