I have a problem with creating this database.
I want to create the student record system. I have a table containing Individual information and using of ID as primary key.
For registering grades I use another table for grades. But here is the problem. Here we have 6 or more class with different courses.
Firstly, I should to permit the user for adding more classes and then more courses to these basic assumptions. (But how the user can add another table that the relationship between new table and the Ind information table makes sense).
How can I save the grades in table?
It is better to use different table for different class with using different courses as filed in this table.
Or add all the courses in my filed and for each ID I just fill out the course for that class.
Or something else I don't know?
Another problem is when some person has grades with lower than 15, I have to add another grades for this person. This person failed then must have another grade for taking effect in GPA.
Please help me to find the way through these problems.