HELLOOOOOO THERREEEE!!!! IT SOUNDS LIKE YOU WANT SEPERATE TABLES IF THE COLUMNS ARE ALL LINKED TO EACH OTHER!!!! YOU SHOULD COME CLOSER SO WE DON"T HAVE TO YELL!!!

One last thing. If there is enough information to calculate the overall mark from the database then you might want to go ahead and do it as it is part of the notion of a normalized relational...

Sounds like a bad design to me. I am not familiar with foxpro but i would say that it is stupid to have to download the whole data base for any look up. it defeats the point of having a server. ...

First off, the only two tables that are in any sort of normal form are Students and Subjects.
The others do not have a primary key. Secondly, you are repeating information from the StudentSubjects...