Question: can you guess if a student can take many courses...
Can you guess if A STUDENT can take many COURSES and a COURSE can have more than one STUDENT enrolled in the course. In this case, both the "student_id" and "course_id" primary keys become foreign keys and primary keys in a new entity called COURSE-STUDENT. What is the main reason for creating a new entity?
1. to achieve data consistency
2. to eliminate possible data redundancy
3. to reinforce data accuracy