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" 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?

a. To reinforce data accuracy
b. To preserve data completeness
c. To eliminate possible data redundancy
d. To achieve data consistency

Answer 1

Answer:C. To eliminate possible data redundancy.

Explanation:Data redundancy is a term used in data management system or process to mean the storage of the same data in different locations, this type of situation need to prevented for effective and efficient data management system or process.The main reason for creating a new entity is to eliminate the possibility of data redundancy which not desireous and not required.