How to structure a daily student update DB
Have a table with a list of student (problem children). We track the current status of each. For example (on medications, needs extra supervision.....) We have a list of these. I was thinking of a table with a field for each (maybe just a check mark). The types of reports I need are for example, history of when each status change, current status.
My question is sould each status change require that each field be copied or can updates only change on field. Not really sure how best to do this.I am even having a little difficulty explaining so I hope this makes sense.