I'm on the same lines as you ICTgeek but not sure about the performance table being required. The second task states selecting the production and indicating which production job the student is to be assigned to. This doesn't indicate assigning to individual performances. On first look my interpretation is that the assumption will be roles filled for all the performances of that production and something for the evaluation. Although performance were required then the foreign key in tblRoles would need to be PerformanceID. EDIT: I've read the report requirements and see where Performance comes in and why you have put productionid as the foreign key.