If you are still around may I ask a question - I'm also taking a database class and had a very similar exercise. We had to make a junction table to relate two many-to-many tables. (Sorry if I'm using the lingo all wrong I'm very much a noob.) So if you say that composite keys are all a pain then...