| 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 |