Sorry to bother you again. I have come across another problem in this assignment of mine.
It is like this: There is the Student entity (Student_ID, First_name, etc), Module entity (Module_ID, Module_Name, etc.). Now I need to find some way to store the assessment results of the students in their respective modules.
You will notice that Student and Module have a many-to-many relationship, so I have introduced a weak entity to simplify this. It is called Student Module Registration. Now I'm tempted to create a new entity called Assessment and create a relationship betwen Assessment and Student and Module.
Problem is, Assessment does not seem to have any primary key and it seems to be just another weak entity, just like Student Module Registration. Is it possible for Student and Module to be related to another weak entity? What would be a better solution than this?