Our initial thoughts were five tables with a table for Wizard of Oz characters and separate table for the production jobs. We've now arrived at a more efficient database system with only four tables (Students, CastList, ProductionJobs, Productions). The ProductionJobs table contains a Boolean field for the allocation of each job. The CastList table then stores assignments with ProductionID, JobID and StudentNo included. I'd be interested in any opinions on this proposal.