| 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. |
| id | degree_name | duration |
|---|---|---|
| 1 | Bachelor of Computer Science | 4 |
| 2 | Master of Mathematics | 2 |
| 3 | PhD Physics | 6 |
| id | department_name | head_id |
|---|---|---|
| (→ Employee.id) | ||
| 1 | Computer Science | None |
| 2 | Mathematics | None |
| 3 | Physics | None |
| id | faculty_name | department_id |
|---|---|---|
| (→ Department.id) | ||
| 1 | Dr. John Smith | 1 |
| 2 | Professor Jane Doe | 2 |
| 3 | Assistant Professor Bob Johnson | 3 |
| 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 |
| id | student_id | course_id |
|---|---|---|
| (→ Student.id) | (→ Course.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| id | first_name | last_name | field_of_study_id | degree_program_id | |
|---|---|---|---|---|---|
| (→ Field_of_study.id) | (→ Degree_program.id) | ||||
| 1 | Alice | Smith | alice@example.com | 1 | 1 |
| 2 | Bob | Jones | bob@example.com | 2 | 2 |
| 3 | Carol | Williams | carol@example.com | 3 | 3 |