Question: Draw an entity-relationship diagram (ERD) in the third normal form for a student database record system based on the following situation: A student may register

Draw an entity-relationship diagram (ERD) in the third normal form for a student database record system based on the following situation:

A student may register for many courses, and a course may have many students.

A student may have many professors, and a professor may teach many students.

A student is assigned only one counselor, but each counselor usually has many students.

Fill in each empty cell in the table below with either TRUE or FALSE.

Item

Is an entity

Is one-to-many

Is many-to-one

Is an associative entity

Counselor to Student

Professor to Student-Professor

Student-Professor to Student

Course to Student-Course

Student-Course to Student

Counselor

Student

Professor

Course

Student-Professor

Student-Course

***Note that for the third normal form ERD, any of its many-to-many relationships must be converted into two one-to-many relationships using associative entities. For this question, assume that there are attributes associated with the relationship so it is okay to model a many-to-many relationship with an associative entity.

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!