This will be helped for my project.
CLASS_STUDENT
ID CLASS_ID USERNAME_STUDENT SEMESTER_ID
-----------------------------------------------
1 1 JOHN 1
2 1 SMITH 1
3 2 MARK 1
4 2 DAVID 1
5 2 STEVEN 2
6 2 MARY 2
LESSON_TEACHER_CLASS
ID LESSON_ID USERNAME_TEACHER CLASS_ID SEMESTER_ID
--------------------------------------------------------
1 102 ALBERT 2 1
If I insert a row above, all students from CLASS_ID=2 will be inserted to GRADES table
as shown figure below.
GRADES
ID USERNAME_STUDENT LESSON_ID CLASS_ID SEMESTER_ID USERNAME_TEACHER MARK
----------------------------------------------------------------------------------------------------------------
1 MARK 102 2 1 ALBERT
2 DAVID 102 2 1 ALBERT
thanks for your solutions