1. Engineering
  2. Computer Science
  3. can you guess if a student can take many courses...

Question: can you guess if a student can take many courses...

Question details

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

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution