ER Modeling I - Q2

INSTRUCTOR (InstructorID, HighestDegree, …)

COURSE (CourseID, ClassTitle, …)

CLASS (ClassID, CourseID, InstructorID, Term…)

TRAINEE (TraineeID, …)

ENROLL (TraineeID, ClassID, Term…)*

All foreign keys not null.

* Optionally, create an EnrollmentID attribute to use as primary key.

Previous slide

Next slide

Back to first slide

View graphic version