Students

idnameagegendermajorId
1Bob Johnson20Male1
2Emma Wilson22Female2
3Tom Clark19Male3

Majors

idname
1Computer Science
2Mechanical Engineering
3Electrical Engineering

Departments

idname
1Engineering Department
2Art Department

Professors

idnamespecialtydepartmentId
1John DoeComputer Programming1
2Jane SmithRobotics3
3Alice BrownCircuit Design2

Academics

idacademicCourseprojectdepartmentId
1Engineering ClassSustainability Project1
2Engineering ClassSoftware Development Project1
3Design ClassSustainability Project2
4Design ClassWeb Design Project2