hey, i'm trying to work out performance marks for a student database and i'm unable to. needed some help.
baically i have a table called assessments which contains fields ass_id,weight,Type and Module code.
I have another table that contains details about students.
and finally i've linked the 3 tables 'takes' up having the following fields: ass_id,module_code,S_id,marks, grade,Year_offered.
i want to try get the average marks for each student for each year. so for example i want to calculate the average for the 2010 for a different students taking various modules which can be either examination or coursework or both. the weights for the assessment are in the assessment table while the marks attained are in the takes table. and i want to display this data in a new table containing the different students and their averages for the year.
i know it's really complicated but anyone who has an idea what to do?
would be really helpful.
thanks
baically i have a table called assessments which contains fields ass_id,weight,Type and Module code.
I have another table that contains details about students.
and finally i've linked the 3 tables 'takes' up having the following fields: ass_id,module_code,S_id,marks, grade,Year_offered.
i want to try get the average marks for each student for each year. so for example i want to calculate the average for the 2010 for a different students taking various modules which can be either examination or coursework or both. the weights for the assessment are in the assessment table while the marks attained are in the takes table. and i want to display this data in a new table containing the different students and their averages for the year.
i know it's really complicated but anyone who has an idea what to do?
would be really helpful.
thanks
