Student Details Table design with semester

Yeshey · March 4th, 2009, 11:36 PM

Hi,

How to design a table for student details with the Exam marks? This doubt came to my mind when I am designing the Application to Stored the Student details.

Students with same programme can go up to various semester say semester 1,2,3,4... so on... So I need to keep the marks details of students from semester 1 till a student complete the programme. So, how to design the table for the above doubt.

I am using the backend as SQL Server 2000.

Your help is very appreciated.Thanks in advance.

Yeshey.

gbianchi · March 5th, 2009, 06:35 AM

Hello...

You need a table to store studends ID (maybe with all the data) and another table that store the studentid, semester, and grades (probably a course id and the grade, with another table for description of courses.).

Tell me if you don't understand.

Yeshey · March 5th, 2009, 06:50 AM

Hello gbianchi,

Thank you for your suggestion. I have already designed the tables as similar to ur suggestion. But my doubt is when current semester students (say 2nd semester) get through the semester and reached to next semester 3. Then where to update the student_ID with semester number and how to save the previous semester result with same student_ID.
Could you give me some hints? Thank you once again for the post.

Yeshey

gbianchi · March 5th, 2009, 07:12 AM

I don't understand you. Then you will have a new row on the table that holds grade with the new semester.

Yeshey · March 8th, 2009, 01:14 AM

Hello gbianchi,

I will make very simple question. Actually I have semester_detail tables with student_ID,semester,Year,Programme_code. Lets say in Student_details table I have student_ID,student_name,programme_code,semester..s o on. Then when the present semester student goes to next semester I want the current semester record with mark details even student reached to next semester. I have marks_details table with student_ID,CA_Marks,Exam_marks,Subject_code,Course _code. So, finally I need to change the Semester twice and Year once (since two semester in a year). When I modify the semester in Student_details table, it should automatically added same student_ID with semester in the semester_details table. How should it be done? But I shouldn't modify the existing data in semester_details table as well as marks_details table but only to append the data. Your help will be helpful.

Thanks
Yeshey

gbianchi · March 8th, 2009, 08:39 AM

I don't follow you (your simple question sounds very complex! :) ). Anyway, if the student is present for more than a semester, you just have a row for every semester (and course and subject). You don't delete or change anything, you just add. Usually a student is for more than one semester studying something. In fact, you usually don't care about the semester, you usually care about courses, cause that the student is doing, studying courses!
The semester is just the data on when, but is not important (well, not that important).

rstelma · March 8th, 2009, 05:22 PM

What are marks details?

You should not have to change any data when a new semester starts. You should only have to add a new row in the semester table. Students take different classes each semester as you know so only rows need to be added to the classes table.

I may be totally off the mark but your questions are really just an exercise in database normalization. Please look that up and read as much as you can. I'm sure you will find most of your questions answered there.

We could also be more helpful if you could write what you need to accomplish in your table design.

Thanks,
Richard

gbianchi · March 8th, 2009, 07:32 PM

Quote:

Originally Posted by rstelma

I may be totally off the mark but your questions are really just an exercise in database normalization. Please look that up and read as much as you can. I'm sure you will find most of your questions answered there.

You think is homework Richard??

could be.