Textbooks

idtitleauthor
1Introduction to Computer ScienceJohn Doe
2Physics for Scientists and EngineersSerway & Jewett
3Chemistry: The Central SciencePaula B. Welch
4Biology: The Dynamic UniverseJames S. Aber
5Mathematical Methods for PhysicistsMichael Abramowitz

Supplies

idnamequantity_needed
1Lab Coats10
2Goggles20
3Bunsen Burners8
4Scales3
5Beakers25

Projects

idproject_namedescriptionsupplies_idtextbook_id
(→ Supplies.id)(→ Textbooks.id)
1Electric Circuit ExperimentDesigning an electric circuit using various components.11
2Acids and Bases LaboratoryIdentifying different types of acids and bases.22
3Molecular Model BuildingCreating molecular models based on chemical formulas.33
4Optical SpectroscopyAnalyzing light absorption patterns of elements and compounds.44
5Calorimetry MeasurementsMeasuring heat capacity using a calorimeter.55

Students

idstudent_nameageclass_id
1Alice Smith161
2Bob Johnson171
3Charlie Brown162
4Diana Prince172
5Emma Watson163

Teachers

idteacher_namesubjectclass_id
(→ Students.id)
1Mr. GreenPhysics1
2Ms. BlueChemistry2
3Dr. RedBiology3
4Professor WhiteMathematics1
5Assistant Professor BlackComputer Science1