Database: University Example: Section

All courses are taught in sections or classes. These sections have students (M:N), professors (M:1), locations (M:1), etc.

Section Table

Section
section_idPKArbitrary primary key
section_num Section number 1, 2, ... at an Ed Center
course_idFKCourse which this is a section of.
edcenter_idFKEd_Center where it's taught.
instructor_idFKInstructor who is teaching it.

As with many tables, this has an arbitrary primary key (section_id). Each section is an instance of teaching one course, and has one instructor.

Section - Sample Data

section_idsection_numbercourse_idinstructor_id
113392