id | name | age |
---|---|---|
1 | Alice | 20 |
2 | Bob | 23 |
3 | Charlie | 21 |
4 | Diana | 22 |
5 | Evan | 24 |
concept_id | concept_name | description |
---|---|---|
1 | Python Programming | A high-level programming language |
2 | Linear Algebra | The study of vector spaces and linear mappings between them |
3 | Calculus | The study of change and motion |
topic_id | topic_name | difficulty |
---|---|---|
1 | Advanced Python | Intermediate |
2 | Multivariable Calculus | Advanced |
3 | Tensor Analysis | Expert |
subject_id | subject_name | core_concept_id | advanced_topic_id |
---|---|---|---|
(→ Core_Concepts.concept_id) | (→ Advanced_Topics.topic_id) | ||
1 | Introduction to Python | 1 | 1 |
2 | Linear Algebra Applications | 2 | None |
3 | Single Variable Calculus | 3 | 2 |
4 | Multivariable Calculus Theory | 3 | 3 |
5 | Tensor Methods in Physics | 4 | 4 |
enrollment_id | student_id | subject_id | grade |
---|---|---|---|
(→ Students.id) | (→ School_Subjects.subject_id) | ||
1 | 1 | 1 | 87.6 |
2 | 2 | 2 | 92.1 |
3 | 3 | 3 | 81.5 |
4 | 4 | 4 | 79.3 |
5 | 5 | 5 | 98.5 |