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 | 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 | |
---|---|---|---|---|
(→ Studies.id) | ||||
1 | Alice | Smith | alice@example.com | 1 |
2 | Bob | Jones | bob@example.com | 2 |
3 | Carol | Williams | carol@example.com | 3 |