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
Get step-by-step solutions from verified subject matter experts
