Question: Develop an Entity Relational Diagram (ERD) model for the following. A college course is taught by many instructors, and an instructor may teach many courses.

Develop an Entity Relational Diagram (ERD) model for the following. A college course is taught by many instructors, and an instructor may teach many courses. An instructor teaches a section of a course. A course may have one or more scheduled sections, or may not have a scheduled section. Attributes of COURSE include courseID, coursename, and credits. A courseID is a unique value for a given course. An INSTRUCTOR is uniquely identified by an instructorID. Additional information we want to store about an instructor includes the lastname, firstname, and officenumber. A student can take many courses and a course can be taken by many students. A student is uniquely identified by a student ID and attributes of a student include the students last name and first name. Attributes of a SECTION of a course include courseID, sectionID, semester, year, and instructorID. A given section of a course is taught by only one instructor. Students may elect to register for more than one section of the same course. The goal of this database is to relate a section of a course with an instructor and the students who are registered in that section of a course.

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!