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