I have a student database that is to supposedly keep track of one or two activities that they will do every school year. I am trying to figure out a way to do this. Would a recommendation be to use a new table for every school year or would it be better to use one table and add a row for every year with fields for every activity. eg:
Student Name
School yr Activity A Activity B Activity C
2016 ..........x
2017 ........................x
2018........................ x............. x
This is for every students who could be here for ten years
All recommendations would be appreciated.
Thanks