Hi, I’m trying to make a small database for my school for making my students performance analysis easier. I’m doing all this manually in excel since the past 3 years but its getting more and more complicated and time consuming very year so I have thought of shifting to a database.
I have a small background in software engineering but nothing at professional level. Just wanted some advice on the tables and relationships that I would need for this database to work. So my school has grades, then sections for these classes example Grade 7A, Grade 7B, and normal subjects like Science, Maths, English etc. I need to store marks for students for every subject for each year separated term-wise. 3 terms every year.
So this is what I have come up with but not sure if its correct. 3 tables for now. Student, Marks, Class. This is what the relationship looks like (attached image) I should be able to make reports on every student, every class, grade-wise, gender-wise, nationality-wise, term-wise etc etc. Then compare the same student with his last years marks and compare the different grades and sections etc etc. So how to do it? I’m trying it in Ms Access as making reports with the wizard is simpler.
P.S I will be importing all the data through excel sheets into this database.
Student Marks Class
---------------------------------
ID-----------SID CYear
SName CID--------ID
DOB MID CSection
Nationality English CTerm
SEN Maths
Gender Science
I have a small background in software engineering but nothing at professional level. Just wanted some advice on the tables and relationships that I would need for this database to work. So my school has grades, then sections for these classes example Grade 7A, Grade 7B, and normal subjects like Science, Maths, English etc. I need to store marks for students for every subject for each year separated term-wise. 3 terms every year.
So this is what I have come up with but not sure if its correct. 3 tables for now. Student, Marks, Class. This is what the relationship looks like (attached image) I should be able to make reports on every student, every class, grade-wise, gender-wise, nationality-wise, term-wise etc etc. Then compare the same student with his last years marks and compare the different grades and sections etc etc. So how to do it? I’m trying it in Ms Access as making reports with the wizard is simpler.
P.S I will be importing all the data through excel sheets into this database.
Student Marks Class
---------------------------------
ID-----------SID CYear
SName CID--------ID
DOB MID CSection
Nationality English CTerm
SEN Maths
Gender Science
