By Afi83 - 9/23/2009
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 Individual 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.
|
By honomas - 1/10/2010
I will suggest a best method to this.
Master table :
Student Master table - This is the table to enter student info such as Id, Name, address, Tel, etc
Subject Master Table- This is the table to enter subject such as subject, Subject Id, Code
Grade Master Table -This is the table to enter grades such as Grade, description
Classes Master Table -This is the table to enter classes such as Class, description
Transaction tables;
Marks Table : Student Id, Subject ID, Year, Class, Marks
Now you don't need to change tables early or adding new subject or class.
|
|