status = "active" to maintain class and section table with student

Guys iam working with a new project school management system.

my first module is to enter students data. i have all the table related to that everything moved fine.

But now sticking to a new problem.

i had a table student_admission_info

id
admission_no
admission-date
class
section
hosteller/dayschollar
status

through form i have inserted the record successfully.

say for example if Abdul Bazith is studying V std A section in year 2018-2019.

next year he will move to VI std B Section.

but both std record must be preset in the db. in my above table i have a column status(active/inactive). but if it is changed to inactive then the whole data inside the table will not be displayed.

so if a student change form one class to another the class must be changed. but his old records must be present.

what i planned is to have a student_class table with columns

id
student_id
class_id
section_id
status

but there are 800 students in the school means the student_class table will be filled yearly . each year the the student record must be inserted. is this right way?? then there be many records for a single student.

is this right??

kindly some one help please..