## Textbooks

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

## Supplies

id | name | quantity_needed
--- | --- | ---
1 | Lab Coats | 10
2 | Goggles | 20
3 | Bunsen Burners | 8
4 | Scales | 3
5 | Beakers | 25

## Projects

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

## Students

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

## Teachers

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