i need some help on this. My problem is to create two tables as ‘student’ and ‘examResults’, there is seperate columns for subjects in ‘examResults’ table. But the thing is i need to change the subject names when the course syllabus changes, Please help!!!
@scragarMay 18.2007 — #would it not be easier to have 4 tables like so(optimized memory this way, and a whole lot easier):
students<i> </i>+-----------+--------------------+-------------------....... | ID | NAME | address ........ +-----------+--------------------+-------------------.....
exams<i> </i>+-----------+---------------------+---------------------..... | Student | Taken on | score ...... +-----------+---------------------+---------------------....
possible courses<i> </i>+-----------+---------------------+---------------------..... | course ID | Name | other stuff ...... +-----------+---------------------+---------------------....