Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions