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.

I think you must clear what u require because u have added so many ORs that every one gets confused. You tell what exactly will be your inputs and what u expect as output. Add your code with the problem / error area shown clearly so that problem could be solved.

Always Believe in GOD!

You can do it! You just need to think over your designing! Give it a shot!

Louis Fritslet

DBA admin, United Nations

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.

webdesign