| id | title | author |
|---|---|---|
| 1 | Introduction to Computer Science | John Doe |
| 2 | Physics for Scientists and Engineers | Serway & Jewett |
| 3 | Chemistry: The Central Science | Paula B. Welch |
| 4 | Biology: The Dynamic Universe | James S. Aber |
| 5 | Mathematical Methods for Physicists | Michael Abramowitz |
| id | name | quantity_needed |
|---|---|---|
| 1 | Lab Coats | 10 |
| 2 | Goggles | 20 |
| 3 | Bunsen Burners | 8 |
| 4 | Scales | 3 |
| 5 | Beakers | 25 |
| id | project_name | description | supplies_id | textbook_id |
|---|---|---|---|---|
| (→ Supplies.id) | (→ Textbooks.id) | |||
| 1 | Electric Circuit Experiment | Designing an electric circuit using various components. | 1 | 1 |
| 2 | Acids and Bases Laboratory | Identifying different types of acids and bases. | 2 | 2 |
| 3 | Molecular Model Building | Creating molecular models based on chemical formulas. | 3 | 3 |
| 4 | Optical Spectroscopy | Analyzing light absorption patterns of elements and compounds. | 4 | 4 |
| 5 | Calorimetry Measurements | Measuring heat capacity using a calorimeter. | 5 | 5 |
| id | student_name | age | class_id |
|---|---|---|---|
| 1 | Alice Smith | 16 | 1 |
| 2 | Bob Johnson | 17 | 1 |
| 3 | Charlie Brown | 16 | 2 |
| 4 | Diana Prince | 17 | 2 |
| 5 | Emma Watson | 16 | 3 |
| id | teacher_name | subject | class_id |
|---|---|---|---|
| (→ Students.id) | |||
| 1 | Mr. Green | Physics | 1 |
| 2 | Ms. Blue | Chemistry | 2 |
| 3 | Dr. Red | Biology | 3 |
| 4 | Professor White | Mathematics | 1 |
| 5 | Assistant Professor Black | Computer Science | 1 |