Question: Q 3 . Create an ERD for a university system that represents how teachers teach courses. A teacher must teach at least one course, and
Q Create an ERD for a university system that represents how teachers teach courses. A teacher must teach at least one course, and coteaching ie a course taught by more than one professor is allowed for each course. A teacher may teach the same course at different campuses of a university. In this university system, the total number of times a teacher has historically taught a specific course at a specific campus called "TeachingCount" should be recorded.
Attributes are:
TeacherTeacherID TeacherName
CourseCourseID CourseName
CampusCampusID CampusName, Address
You are required to use Lucidchart to create this ERD and identify the primary key in the ERD.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
