RelationShip Among Many Tables

[a_20120]

Can anyOne help me how to Normalize and provide Relationship among 12 Tables in a good way.

Purpose of Tables:

1. Students Registration
2. Subject Registration (Definition) for eight Semesters
3. First, Second, Third, ... Eight Tables of the eight Semesters
4. Entering Marks (Points) for the selected subjects of each student's semester
5. Storing the Result (Pass, Fail, Second Chance, ...) after the marks entered

Note:

1. Consider the Result Table, because it should related to other tables and cab be able to keep the results of th sudents into it, like Pass, Fail, Second Chance,... after the Marks entered
2. All the above will be through the Forms.

Request:
If anyOne has Faculty Project in Access, VB, Delphi please send me at
a_20120@yahoo.com

 

[MarkK]

You want a student table and a subject table. These are obvious.
Then you want a table that relates any student to any subject. This relationship includes the semester (or date) the student took the subject and the grade achieved.

[B]Student[/B]
[COLOR="Green"]'information about the student[/COLOR]
stuID
Name
etc...

[B]Subject[/B]
[COLOR="Green"]'information about the subject[/COLOR]
subID
Name
etc...

[B]Grade[/B]
[COLOR="Green"]'information about how the student and the subject are connected to each other.  
'this includes dates, semesters, grades, and maybe teachers...[/COLOR]
ID
stuID
subID
[COLOR="Green"]'teacherID[/COLOR]
Semester
Grade
Year
etc...

Note that time values, whether these be dates or semesters, should not be in separate tables distinguished by quantity. Consider an accounting example: You do not make a table for transactions below $100 and a new table for transactions over $100. You make a transactions table, end of story.
Time is like money in this respect: it is a variable quantity. Table distinctions should not be made on the value of data.

Hope you find this useful,

 

[a_20120]

Hi Mr. LagBolt

Thanks very Much.

Could you guide me more for the following...

At the end of the Semester after Entering the Student Marks (Points) that he/she optained.

Condition:

1. Where Store the Result (Pass, Fail,...)
2. if the result is Fail, then he/she must take exam again to pass. Where store the First exam Mark, and where store the Second exam Marks.
3. How increase the Student to the next Semester