I want to make a database that keeps track the students' marks for carry mark( quiz, homework and project) and final mark (q1-q2)
STUDENT
stu_id
stu_name
stu_year
stu_section
stu_semester
FINAL
final_q1
final_q2
final_q3
stu_id
CARRY
ca_quiz1
ca_homework
ca_project
I planning to link these with php.
My question is: What happen there are more than one quiz. For example, there is only one quiz but in the next semester there will be 3 quizzes. What should i do to accomadate these changes. Should I make another table?
TQ in advance.
