Use php mysql: When the teacher selects a class, an option will appear to choose the subjects for that class only and not all subjects. Then all students will watch for that class so that the teacher can enter the grades for the first test, second test, midterm, and final test.

Note: The teacher cannot enter all the grades at once. He can only enter the grades for the first test, but when the test comes again, he can make changes on the same page. so the add result and update in one forms.

An image showing the desired page desgin forms

tables structure

CREATE TABLE IF NOT EXISTS $`$tblresult$1`($

$`$id$`$ int NOT NULL,

$`$StudentId$`$ int DEFAULT NULL,

$`$ClassId$`$ int DEFAULT NULL,

$`$SubjectId$`$ int DEFAULT NULL,

$`$quiz$1`$ varchar$(4)$ DEFAULT NULL,

$`$quiz$2`$ varchar$(4)$ NOT NULL,

$`$midterm$`$ varchar$(4)$ NOT NULL,

$`$final$`$ varchar$(4)$ NOT NULL,

$`$PostingDate$`$ timestamp NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NULL DEFAULT NULL ON UPDATE CURRENT$\_$TIMESTAMP

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$latin$1$;

$------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------$

DROP TABLE IF EXISTS $`$tblclasses$`$;

CREATE TABLE IF NOT EXISTS $`$tblclasses$`($

$`$id$`$ int NOT NULL AUTO$\_$INCREMENT,

$`$ClassName$`$ varchar$(80)$ DEFAULT NULL,

$`$Section$`$ varchar$(5)$ NOT NULL,

$`$CreationDate$`$ timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NOT NULL DEFAULT $\text{'}0000-00-0000$:$00$:$00\text{'}$ ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB AUTO$\_$INCREMENT$=2111115$ DEFAULT CHARSET$=$latin$1$;

$------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------$

DROP TABLE IF EXISTS $`$tblsubjects$`$;

CREATE TABLE IF NOT EXISTS $`$tblsubjects$`($

$`$id$`$ int NOT NULL AUTO$\_$INCREMENT,

$`$SubjectName$`$ varchar$(100)$ NOT NULL,

$`$SubjectCode$`$ varchar$(100)$ NOT NULL,

$`$Creationdate$`$ timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NOT NULL DEFAULT $\text{'}0000-00-0000$:$00$:$00\text{'}$ ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB AUTO$\_$INCREMENT$=46$ DEFAULT CHARSET$=$utf$8$mb$3$;

$------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------$

DROP TABLE IF EXISTS $`$tblstudents$`$;

CREATE TABLE IF NOT EXISTS $`$tblstudents$`($

$`$StudentId$`$ int NOT NULL AUTO$\_$INCREMENT,

$`$StudentName$`$ varchar$(100)$ NOT NULL,

$`$RollId$`$ varchar$(100)$ NOT NULL,

$`$ClassId$`$ int NOT NULL,

$`$RegDate$`$ timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NULL DEFAULT NULL ON UPDATE CURRENT$\_$TIMESTAMP,

$`$Status$`$ int NOT NULL,

PRIMARY KEY $(`$StudentId$`),$

UNIQUE KEY $`$RollId$`(`$RollId$`)$

$)$ ENGINE$=$InnoDB AUTO$\_$INCREMENT$=518$ DEFAULT CHARSET$=$utf$8$mb$3$;