Hello,
I am looking for suggestions on design of a database. I have 1000's students and multiple classes that run each year. The Students will only complete some of the classes. My plan is to create a Table with the class names and date of class (ClassT). I have a Table with all the student info (StudentT).
Should I create a Table with a column with names of the classes (ClassT) as a lookup and a column with the students (StudentT) as a lookup.
Then run a query to show class rosters.
Thoughts or suggestions would be helpful.
Thanks