How can i create table for academic details

[luckysanj]

I have problem on creating academic table.
I need to input from html form to different academic table.
But how to create academic table for my requirement.

I have different leve of student.
Like

SLC Borard Pass Year Division Percentage

Intermediate Pass Year Division Percentage

Bachelor Pass Year Division Percentage

Master Pass Year Division Percentage


In the above table every filed need pass year, division, percentage. So how can i manage this table on database.

Plz help me. Ur help will be appereciated

[Atli]

Hi.

Assuming, I am understanding you correctly, this could be solved using a one-to-many relationship (1:N).

Meaning that you would create two tables.
One to contain all the common data (pass, year, etc...), and a second one to contain the student levels.

Consider this:

StudentData:
+----+------+------+--------+
| ID | Type | Year | etc... |
+----+------+------+--------+
|  1 |    1 | 2009 | ...    |
|  2 |    2 | 2005 | ...    |
|  3 |    1 | 2007 | ...    |
|  4 |    3 | 2002 | ...    |
+----+------+------+--------+
 
StudentType:
+----+--------------+
| ID | Name         |
+----+--------------+
|  1 | Intermediate |
|  2 | Bachelor     |
|  3 | Master       |
+----+--------------+

Where the "Type" field in the Data table references the ID field of the Type table.

Does that answer your question?
If not, please elaborate.

[luckysanj]

Thank You .