I'm trying to build a database for students official exams where a student study in a school and does his official exams in a different school.
My current CDM:
After converting this CDM into PDM then into SQL I'm having some problems using the database.
My problems with the current design is:
- Student table has a
SCHOOLIDfor the school that the student studies in and
SCH_SCHOOLIDfor the school the student will be doing his exams in and this is what I actually want. The problem is that I'm not sure how to link the student exam school with his
SEATin that school.
- Another thing I need in my database is that one or many
CLASScan have the same
EXAMwith the same
LANGUAGEor in a different
LANGUAGE. The generated SQL does not seem to provide the option to do that.
Any help on how I can improve my CDM to get the desired result is much appreciated.