School database structure
Hi everyone,
I have created a database in Oracle 10g for a school where we manage all the grades, but when the school year ends I have to create a new school year by creating the new classes and adding new students and the way I do this is by importing all the data from a .txt file provided for our director.
What I would like to know is where should I put the old classes from the school year that just passed and if the best way to do this is by creating another table to put the old data using the school year to identify each year in case we need to print a report?
Can anyone please help me to create the structure of that table?