Question: 1- A STUDENT can take many COURSES and a COURSE can have more than one STUDENT enrolled in the course. In this case, both the

1- 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 achieve data consistency

To eliminate possible data redundancy

2- What is a "composite" primary key?

A set of foreign keys

A set of two or more attributes that uniquely identifies an entity instance

An attribute we make up when no primary key is given

A primary key that is difficult to understand

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!