"how do i change the column names as required" Please Help!!

[UI-ZEIKVK]

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!!!

[scragar]

would it not be easier to have 4 tables like so(optimized memory this way, and a whole lot easier):

students
+-----------+--------------------+-------------------.......
| ID | NAME | address ........
+-----------+--------------------+-------------------.....

student courses

+-----------+---------------------+---------------------.....
| Student | Started | Ends ......
+-----------+---------------------+---------------------....

exams
+-----------+---------------------+---------------------.....
| Student | Taken on | score ......
+-----------+---------------------+---------------------....

possible courses
+-----------+---------------------+---------------------.....
| course ID | Name | other stuff ......
+-----------+---------------------+---------------------....

[UI-ZEIKVK]

Thank you scragar, Now I've got some idea with your help, Thanks!Thanks!!Thanks!!! :)