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 |