Question: 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
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?
| To reinforce data accuracy | ||
| To preserve data completeness | ||
| To eliminate possible data redundancy | ||
| To achieve data consistency |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
