## Studies

id | name | description
--- | --- | ---
1 | Computer Science | The study of computers and computation.
2 | Mathematics | The study of numbers, quantity, structure, space, and change.
3 | Physics | The natural science that involves the study of matter and energy.

## Department

id | department_name | head_id
--- | --- | ---
|  | (→ Employee.id)
1 | Computer Science | None
2 | Mathematics | None
3 | Physics | None

## Faculty

id | faculty_name | department_id
--- | --- | ---
|  | (→ Department.id)
1 | Dr. John Smith | 1
2 | Professor Jane Doe | 2
3 | Assistant Professor Bob Johnson | 3

## Course

id | course_code | title | credit | faculty_id
--- | --- | --- | --- | ---
|  |  |  | (→ Faculty.id)
1 | CS101 | Introduction to Programming | 3 | 1
2 | MATH201 | Calculus I | 4 | 2
3 | PHYS101 | General Physics | 3 | 3

## Enrollment

id | student_id | course_id
--- | --- | ---
| (→ Student.id) | (→ Course.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3

## Student

id | first_name | last_name | email | field_of_study_id
--- | --- | --- | --- | ---
|  |  |  | (→ Studies.id)
1 | Alice | Smith | alice@example.com | 1
2 | Bob | Jones | bob@example.com | 2
3 | Carol | Williams | carol@example.com | 3