depends enitrely on how your academic institution handles things
bear in mind any assessed mark may go to a review board, an overall year mark can also go to a review board and be adjusted up or down
a student can object to an assessment and request a remarking.
some instituions apply penalties for late, too little / too much (as if!) coursework.
some courses carry forward marks formt he previuous year into this years or final years mark.
So an individual piece of coursework that is handed in and marked may contribute to the end of year assessment
it may attract a penalty of being late, or too short
it may attract a credit because the student is dyslexic, or otherwise non standard
the course work may be mandatory (ie the student has to complete (or attempt or pass it) some courses actually do have mandatory coursework which has to be attneded, but dont' require a pass
the module may or may not be examined, it may or may not have an element of coursework (that element of coursework may comprise several pieces of coursework
some coursework may be laboratory practical, some may be essays / reserach.
some modules may be common to many courses
some modules may be worht more than other modules to the final year assessment.
some students can take more modules than they are actually required to take. say a student requires 120 credits to complete the year, its possible that they may study 120...180 credits you need to decide how to handle the amrks for these over acievers (ie do you take the average of all units, do you take a weighted average, do you take the best 120 credits worth and ignire the rest....)
some students may be registered for more than one course in any one acadmeic year - so you need to be able to handle that (ie make sure that you only pull thre right results for the right course.
some course have specific pass / fail / grade thresholds some don't.
how do you propose to handle resits (bearing in mnind that a student may resit a course, a module(s) both in the summer, the autumn, the following exam year. a student may have to resit exams, coursework or the whole module. if they are in resit then you may have to apply a penalty to their following grade
so for each module, in an ideal world you need to know the types of assessed (marked) work and how much they contribute to the final year mark. (eg the exam(s) are worht 60% of the final year mark, and the total of the coursework is worth 40% - but you need to know if that is 4 x 10%, or 15%,15%,5% & 5%)
some moduels are optional, some are mandatory, some are required for a specific sub option
that means you need a table identifying coursework being undertaken in that year for that course
you need another table identfying what assessed pieces of work that student did (it should map directly back to the student and the pieces of coursework
its optional if you want to store a moduel assessment (probably a good idea to do so)
its optional if you want to store a course assessment (probably a good idea to do so)
you need to build in the variuous review stages and decisions made at the exam board (eg pass, fail, grade, adjustment and probably include reasons.
you need to have a clear track record of what happenened to the original mark
eg student "wrist" is taking a dbdesign module as part of a degree
that moduel has a piece of assessed coursework (say to design a student record system
wrist hands in the work late with too many tables
the coursework is marked as 55%
however the work was handed in late - penalty - 10%
and had too many tables (the academic couldn't be bothered to look in detail at the design) - 10%
meaning the the mark is now 35% a borderline fail
this brings the year average low so the exam board may review the marks and decide to rescind the penalties. however another academic believes the piece of work is copied (ie isn't the students work (say he copied it from dbforums.com) and the board elects to zero the mark instead.
student fails the year, is called before the exam board - paints a clever picture as to how its all his own work and dbforums wasn't that relevent or helpfull, mark reinstated. the exam board finding that their are too few passes inthis particular course and therefore decides to adjust the results for all / most students to ensure that they achieve government and universtiy targets and ass 10% to all student marks to make sure that the course isn't cut next year and that the academics will have to go out and get a proper job.
bear in mind that not all modules may run in any one year (ie it is possible a module smay exist, but no one is doing it this year, equally its possible that the same module may appear in more than one course, and in more than one academic year (ie module xxx can be taken in year 1, 2 or 3) I presume your model is going to say student enrollment is a function another external system - if thats not the case ruight now, then do so enrollment is fiendishly complex).
a course comprises several modules, some of which are optional
some modules may be offered in differnt courses (and different years within the course)
a module may comprise many pieces of assessed work
a student registers for a course and modules
I'd rather be riding on the Tiger 800 or the Norton