Ok, so I've created a new table called ExamResults. It has a primary key of ExamRes_ID, and foreign key columns for StudentID and ExamID. In designing the rest of the table, though, I remembered another reason I thought I needed multiple tables in the first place: each exam has a different number of questions, with various values that need to be tracked for each.

So, to track data for each question —answer chosen, answered correctly, time spent viewing that question, and so on — it seems like I would either need to create a different ExamResults table for every possible number of questions (so I can have Q1Response, Q1Correct, Q1Time . . . Q[X]Response, etc)...or else leave it as a single table, create a number of columns to match the maximum number of questions, and pass in nulls for exams that don't have that many questions. Once again, neither of these seems optimal.

Would someone be kind enough to tell me what I'm missing now?