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.

Below is the database structure I would start with:

Student: ID, Last Name, First Name, etc
Course: ID, Course Name
Section: ID, Course ID, Section Name
Enrollment: ID, Section ID, Student ID
Assignment: ID, Section ID, Assignment Name
Grades: ID, Student ID, Assignment ID, Grade

I can't understand how can i relate different course subject to each grades relate to that subject.
Please say some more guidelines.
Also what about the failed grades and where to save other grades related to this subject and using that for accounting GPA.

You can join the grade table to the section table and then join that to the course table. If you need to track a subject, you can add a subject table and have a foreign key in the course table to record which subject it is for.

To find out GPA, you simply take the grades in the grade table join to the student table and the section table and perform the necessary calculations. The method of how you calculate GPA will dictate the actual query design you use.

Excuse me
But if you can send a access file containing the relationship because i can't understand the true relationship in this case.

Also please explain about the failed grades of each student and keep track of them.

I gave you the tables I would use for this database above. As far as the relationships:

course-section: one-to-many
section-enrollment: one-to-many
section-assignment: one-to-many
grades-assignment: many-to-one
grades-students: many-student

After reviewing the design, I found that you can use enrollment ID in the grades table instead of student ID; using the enrollment ID would probably be best.
You should be able to create your own database in access from there.

This is for school work isn't it?

No not at all, This is not for school. Really I am graduated. I have M.sc degree in Genetics. But because i did not do any database design I get into trouble for doing this. This is program for my military service I want to use some privilege by doing this.

If someOne can guide me please help.
Thanks in advance for all of responses to this thread

Dear Friends

The attachment is my effort for creating the ERD for the question.
Please check it for correctness or wrongness.

Thanks in advance

How does your design track which classes the grades are for? How does your design track each assignment? Is each major a part of a field? What do the penalty and class tables track? How does your table track which class the faculty are teaching?

I would suggest you start with the suggestions I made in this thread, create the ER diagram and go from there.