Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started