I am developing a school management system.
Most data will not be reused after the end of the school year.
I am contemplating using schemas to separate data in various school years, however I am afraid I don't know very much about schemas.
Would it be a good idea to use a new schema for each school year to store data (see below), rather than adding a
year field and using a
where clause for all queries?