Hello,
I have the following problem:
I have the PERSON table and COURSE table, each person can choose more than one course, the id of the chosen courses need to be saved within the person table, what would be the best way to do it?
Hello,
I have the following problem:
I have the PERSON table and COURSE table, each person can choose more than one course, the id of the chosen courses need to be saved within the person table, what would be the best way to do it?
Ideally you'd have a table template look like this:
Inthesecasesyouaskyourself:
When we encounter this situation of NN there is a need to create an auxiliary table to connect the two tables that in the case is the table "Person_Course", it exists only for the purpose of making the connection of Person with Course.