id | name | available_resources |
---|---|---|
1 | Science Lab | Computers |
2 | Science Lab | Microscopes |
3 | Art Studio | Computers |
4 | Art Studio | Paints |
id | resource_name |
---|---|
1 | Computers |
2 | Microscopes |
3 | Paints |
id | course_title | instructor | duration |
---|---|---|---|
1 | Introduction to Chemistry | Dr. Smith | 60 |
2 | Advanced Physics | Prof. Johnson | 90 |
3 | Beginner Painting Techniques | Ms. Davis | 80 |
4 | Abstract Art | Mr. Brown | 75 |
id | student_name | age | courses_attending |
---|---|---|---|
1 | John Doe | 20 | {1} |
2 | Jane Smith | 21 | {2}, {3} |
3 | Alice Johnson | 22 | {2}, {4} |
4 | Bob Brown | 23 | {1}, {3} |
learning_space_id | resource_id | course_id | student_id |
---|---|---|---|
(→ Learning_Space.id) | (→ Resource.id) | (→ Course.id) | (→ Student.id) |
1 | 1 | 1 | 1 |
1 | 2 | 1 | 1 |
2 | 3 | 2 | 2 |
2 | 1 | 2 | 2 |
3 | 3 | 3 | 3 |
3 | 4 | 4 | 4 |
4 | 1 | 1 | 1 |
4 | 2 | 3 | 2 |
4 | 4 | 4 | 3 |
4 | 1 | 4 | 4 |