Thanks again for replying, nimesh. You rule! And I'm really sorry to have created this new thread for the same problem. Won't happen again.
About the Student-Assessment relationship, a student has to choose 2 modules if part-time, and 4 modules if full-time. Can a combination of both Student_ID and Module_ID be used as candidate keys in the Assessment table in this case?