Level 21
2nd one is best approach ☺️
1 like
Sep 22, 2024
3
Level 2
mySql Repeat relation
Hello, i have 3 table : courses, lecturers, course_lecturers(many to many)
now i want to create another table for lecturer finances of this course
first i can make it : id, course_id, lecturer_id, ......
second i cane make it : id, course_lecturer_id (which has the relation of course,lecturer)
which one is correct =?
Level 2
@Shivamyadav Thanks a lot, but can you please explain why?
Level 21
@TarikAli The second option (using course_lecturer_id) is the more normalized and efficient approach. It avoids redundancy and ensures that the financial data is always tied to a valid course-lecturer combination already defined in the course_lecturers table.
Please or to participate in this conversation.