Field_of_study

idnamedescription
1Computer ScienceThe study of computers and computation.
2MathematicsThe study of numbers, quantity, structure, space, and change.
3PhysicsThe natural science that involves the study of matter and energy.

Degree_program

iddegree_nameduration
1Bachelor of Computer Science4
2Master of Mathematics2
3PhD Physics6

Department

iddepartment_namehead_id
(→ Employee.id)
1Computer ScienceNone
2MathematicsNone
3PhysicsNone

Faculty

idfaculty_namedepartment_id
(→ Department.id)
1Dr. John Smith1
2Professor Jane Doe2
3Assistant Professor Bob Johnson3

Course

idcourse_codetitlecreditfaculty_id
(→ Faculty.id)
1CS101Introduction to Programming31
2MATH201Calculus I42
3PHYS101General Physics33

Enrollment

idstudent_idcourse_id
(→ Student.id)(→ Course.id)
111
222
333

Student

idfirst_namelast_nameemailfield_of_study_iddegree_program_id
(→ Field_of_study.id)(→ Degree_program.id)
1AliceSmithalice@example.com11
2BobJonesbob@example.com22
3CarolWilliamscarol@example.com33