SQL Assign Teachers And Sections

I have

Tables [Teachers ]

Table Class having 1, 2, 3

Table Section having A, B, C

All Teachers are mounted permanently as ClassTeachers for each class 

Now, How can I assign one Class Teacher to monitor a class Section temporarily via Sql Insert/Update in a situation where particular Class Teacher is not around

What is the Sql Schema Design like? Thanks