I'm trying to setup a student grading system(SGS) but finding it difficult to set up the tables and the appropriate relationship. The SGS is as follows
1. the school system runs an academic session so i will create a table called SESSION
2. each session is divided in to three parts called (1st Term, 2nd term , 3rd Term) so i will create a table called Terms to hold the three terms
3. each of those three terms conduct three examinations before proceeding to another term that is three exams in 1st term before moving to 2nd term and another three exams in 2nd term before moving to 3rd term and after 3rd term, a new session starts with 1st term
4. Each of those three examinations are graded and similar subjects are taken in all examination ( i think i need a Table of SUBJECT) and the the Totals of the first, second and third exam is cummulatively added together in the third examination every term.
5. The examination are conducted at different classes called (primary1, primary2, primary3…....) so i need a Table of CLASS
6. Similar subjects are offered in all the different classes
7. New students are registered into different Classes at a particular term and session and they will offer all the subjects allocated to that Class (i need a Table of STUDENTS)
So how do i relate these tables if i realy need them all ? and at the end of every term I will produce a report of students grades like the piture attached I think I need a linking table of EXAMINATION but don’t know where to place it
i dont know if i'm asking too much , i just need some guidiance
1. the school system runs an academic session so i will create a table called SESSION
2. each session is divided in to three parts called (1st Term, 2nd term , 3rd Term) so i will create a table called Terms to hold the three terms
3. each of those three terms conduct three examinations before proceeding to another term that is three exams in 1st term before moving to 2nd term and another three exams in 2nd term before moving to 3rd term and after 3rd term, a new session starts with 1st term
4. Each of those three examinations are graded and similar subjects are taken in all examination ( i think i need a Table of SUBJECT) and the the Totals of the first, second and third exam is cummulatively added together in the third examination every term.
5. The examination are conducted at different classes called (primary1, primary2, primary3…....) so i need a Table of CLASS
6. Similar subjects are offered in all the different classes
7. New students are registered into different Classes at a particular term and session and they will offer all the subjects allocated to that Class (i need a Table of STUDENTS)
So how do i relate these tables if i realy need them all ? and at the end of every term I will produce a report of students grades like the piture attached I think I need a linking table of EXAMINATION but don’t know where to place it
i dont know if i'm asking too much , i just need some guidiance
