Multiple 2D tables in a single .mdb file

dil4VB
10-20-2004, 09:20 AM
I am designing a form to write and read the mark information
of students. The progress report card is a table containing marks in each subject for every month's exam

(please see msheet.bmp atached file for my mark sheet)

That is a 2D table corresponding to just one student.
I have a table in my database that has the personal
information about each student (one record per student)
and includes the Roll Number that is unique for
each student.

But i cannot store the information in each "cell" in
the above sheet as a field in the student's record.

Can anyone suggest a better idea to store and retrieve
the mark sheet from a .mdb file?

loquin
10-20-2004, 03:12 PM
I am designing a form to write and read the mark information
of students. The progress report card is a table containing marks in each subject for every month's exam

(please see msheet.bmp atached file for my mark sheet)

That is a 2D table corresponding to just one student.
I have a table in my database that has the personal
information about each student (one record per student)
and includes the Roll Number that is unique for
each student.

But i cannot store the information in each "cell" in
the above sheet as a field in the student's record.

Can anyone suggest a better idea to store and retrieve
the mark sheet from a .mdb file?You've undertaken a fairly complex task. The main issue I see is how to design the tables so as to have your data normalized. (See the *** database installments dealing with keys and normalization for more information on these subjects)

You've taken a step in the right direction by separating the student data from the scores data. Now you need to further break down, or normalize, the scores data. I believe you'll need a table to hold information about the subjects. Then, as a child table to the subjects table, you'll need another table to hold info about the Tests (Max points, Classification (Unit, Mid, Terminal, etc.), display order, Name(UT1, MT3,...,) etc.) Finally, you'll need actual scores, which hold links to the tests table and to the student table, as well as specific info about the individual test (Score, date, etc.)

dil4VB
10-20-2004, 06:34 PM
Thanks for the useful guideline and the link. It was much helpful. :)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum