I have two tables 'student' and 'modules'. The primary key in the first one is 'username' and in the second it is 'module_name'. I am trying to create another table called 'student_module', that will have 'username', and 'module_name'(these will be the primary key) and 'exam_date'. In addition to the primary key I want the first two to be foreign keys with reference to the first two tables. Although I have tried everything, this seems impossible!!
Does anyone have any ideas? Thank you!!
Does anyone have any ideas? Thank you!!