Studies

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.

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_id
(→ Studies.id)
1AliceSmithalice@example.com1
2BobJonesbob@example.com2
3CarolWilliamscarol@example.com3