## Students

id | name | age | gender | majorId
--- | --- | --- | --- | ---
1 | Bob Johnson | 20 | Male | 1
2 | Emma Wilson | 22 | Female | 2
3 | Tom Clark | 19 | Male | 3

## Majors

id | name
--- | ---
1 | Computer Science
2 | Mechanical Engineering
3 | Electrical Engineering

## Departments

id | name
--- | ---
1 | Engineering Department
2 | Art Department

## Professors

id | name | specialty | departmentId
--- | --- | --- | ---
1 | John Doe | Computer Programming | 1
2 | Jane Smith | Robotics | 3
3 | Alice Brown | Circuit Design | 2

## Academics

id | academicCourse | project | departmentId
--- | --- | --- | ---
1 | Engineering Class | Sustainability Project | 1
2 | Engineering Class | Software Development Project | 1
3 | Design Class | Sustainability Project | 2
4 | Design Class | Web Design Project | 2