At the moment I have two tables:
SUBJECT GRADE BOUNDARIES(*Subject referance, A, B, C, D, E, U)
RE-MARK SCRIPT(*Candidate number, *Centre number, Title, Surname, Fore Name, Original Mark, Original Grade,Re-mark Mark, Re-mark Grade, Return Script, Date Submitted, Subject Referance, Re-marked Yet?, Grade Changed?, Re-mark Date)
Sample data:
Cand #1, Martin, Maths, Centre #1
Cand #2, Martin, Physics, Centre #2
Cand #1, Martin, Computing, Centre #1
Candidate numbers are unique within each centre only.
I have three questions:
1. Do I need to spit the Re-mark table? Is it in 1st 2nd or 3rd normal form? If not what do i need to do to achieve this?
2. I want the original grade to fill in auto mathematically depending on the subject reference and original mark. Different subject have different grade boundaries. How would i do this automatically?
E.g. if the subject is x and mark is y then the grade is z. I want field z to automatically fill in as A, B, C etc from the GRADE BOUNDARY table
Sample data from grade boundary table:
subjectRef, 80, 70, 60, 50, 40
3. If Field A Does not = Field B then Field C = True. How do i set up conditions like this?
Thanks for a lot for the help, it is really appreciated.
SUBJECT GRADE BOUNDARIES(*Subject referance, A, B, C, D, E, U)
RE-MARK SCRIPT(*Candidate number, *Centre number, Title, Surname, Fore Name, Original Mark, Original Grade,Re-mark Mark, Re-mark Grade, Return Script, Date Submitted, Subject Referance, Re-marked Yet?, Grade Changed?, Re-mark Date)
Sample data:
Cand #1, Martin, Maths, Centre #1
Cand #2, Martin, Physics, Centre #2
Cand #1, Martin, Computing, Centre #1
Candidate numbers are unique within each centre only.
I have three questions:
1. Do I need to spit the Re-mark table? Is it in 1st 2nd or 3rd normal form? If not what do i need to do to achieve this?
2. I want the original grade to fill in auto mathematically depending on the subject reference and original mark. Different subject have different grade boundaries. How would i do this automatically?
E.g. if the subject is x and mark is y then the grade is z. I want field z to automatically fill in as A, B, C etc from the GRADE BOUNDARY table
Sample data from grade boundary table:
subjectRef, 80, 70, 60, 50, 40
3. If Field A Does not = Field B then Field C = True. How do i set up conditions like this?
Thanks for a lot for the help, it is really appreciated.
