See the following partial ERD for a course database design. There are 2 entitites: Department and Course. Only one attribute for each entity is marked in the ERD. The attributes are in ovals. This is …
See the following partial ERD for a course database design. There are 2 entitites: Department and Course. Only one attribute for each entity is marked in the ERD. The attributes are in ovals. This is another typical representation of attributes in ERD. We did not use this representation in the videos but many people use it. The attribute marked for each entity is its primary key. Now to turn this partial ERD to a relational model, which of the following is correct? Capture-1.PNG An associative entity needs to be added to this ERD before it can be turned into a relational model A foreign key DeptID needs to be added to the Course table and A foreign key CourseID needs to be added to the Department table A foreign key CourseID needs to be added to the Department table A foreign key DeptID needs to be added to the Course table
OR