Simple Database Design - Friday Afternoon Brain Meltdown
Trying to knock up (what should be) a very simple database in Access. Student name, class etc - each student has an identical series of goals and two sets of scores plus associated notes for each. I think I'm either over or undercomplicating this, or my brain has just melted on a Friday afternoon. How many/what tables would you break this down into in Access if you were setting this up? I know it's going to be one of those kick yourself when somebody else points it out answers.
Initially, I had a Student table and a ScoreSet1 and ScoreSet2 table but this only left me with 1 set of notes for each ScoreSetX and I need 1 set of notes for each goal. Redid this into a Goals, Student and Scores table but now staring blankly and forgetting how to link it all together so each student would have only 2 entries per 1 goal + notes entry. Doh!