k... i will design the database as per the suggestions here and get back soon for more feedback. do i have to start a new thread or stick to this...

i meant to write like this: exam_year int,

The reason why i am using exam_year is because the marksheet that the system must finally print reads something like this: ...

k regarding foreign keys, i have understood it this way. correct my mistakes.

Subjects table, Students table and Gradetype table will have one to many relationship with Marks table.

so Marks table...

k if i insert a gradetypeID column in the table, that means there will be four rows in the table if the subject has all four possible grade types. one...

i am not a student . i work in the examination cell and i have been trying to develop an application that will replace the current system.

regarding odd/even,...

Odd means odd semester- I,III, and V semesters

Even means even semester- II, IV and VI semesters.

Regular papers means student appears it for the first time.

Compartmental means the student has flunked...

so like this?

Master_marks table with the following columns:

student_id int,

subject_id int,

marks int,

odd_even bit,

reg_comp bit,

exam_year int, '( year is associated with the year of examination and not student)'

gradeID int,

and a...

k if a student appear for the second time, then the reg_comp column value will be compartmental.

if i use bit values, then i have to make another table with only...

k this is what i have been doing so far to record marks of students. i have a marks_master table like this:

marks_id int,

subject_id ...

Now that subjects, grades table is settled , please suggest where I should store the actual marks scored by the students .

If I make a junction table between students...

K now i am getting it. Thank u . But one doubt.

please elaborate how the trigger is to be used and what it's supposed to look like.. I...

yes, all subjects do not have the same pass and full marks for theory and practical grades.

For example, Java subject has 100 and 40 as full marks and pass marks...

k what will be the records for the grades table? like this?

ID Name

1 THET

2 THPA

3 PRET

4 PRPA

and what about the pass...

THET: theory end term grade

THPA: theory progressive assessment grade

PRET: practical end term grade

PRPA: practical progressive assessment grade

here is a sample of a record in the table:

java ...

ScottPletcher (10/21/2015)

---

hlsc1983 (10/19/2015)

---

hi am back after a long time . so sorry for that. Now i need to enter 'Marks ' . Each student will have two types of marks...