StudentID | FirstName | LastName | DateOfBirth |
---|---|---|---|
1 | John | Doe | 1998-06-15 |
2 | Jane | Smith | 2000-10-20 |
3 | Michael | Johnson | 1997-02-25 |
4 | Emma | Williams | 2002-04-10 |
5 | David | Martinez | 1999-08-15 |
TeacherID | FirstName | LastName | SubjectTaught |
---|---|---|---|
1 | Mr. | White | Mathematics |
2 | Ms. | Black | Physics |
3 | Dr. | Green | Chemistry |
4 | Prof. | Red | Biology |
5 | Miss | Blue | English |
ClassID | ClassName | RoomNumber | StartTime | EndTime |
---|---|---|---|---|
1 | Algebra I | 101 | 08:00:00 | 09:00:00 |
2 | Calculus II | 201 | 10:00:00 | 11:00:00 |
3 | General Chemistry | 301 | 12:00:00 | 01:00:00 |
4 | Organic Chemistry | 302 | 02:00:00 | 03:00:00 |
5 | Advanced Physics | 401 | 04:00:00 | 05:00:00 |
LabID | LabName | Location | HasEquipment |
---|---|---|---|
1 | Main Science Lab | Room 100 | 1 |
2 | Computer Lab | Room 200 | 0 |
3 | Art Lab | Room 300 | 1 |
4 | Music Lab | Room 400 | 0 |
5 | Language Lab | Room 500 | 1 |
PurchaseID | LabID | ItemName | Quantity | Cost |
---|---|---|---|---|
(→ Laboratories.LabID) | ||||
1 | 1 | Microscope | 1 | 500.0 |
2 | 1 | Beakers | 50 | 2.5 |
3 | 2 | Headphones | 10 | 10.0 |
4 | 3 | Paintbrushes | 20 | 3.0 |
5 | 4 | Guitars | 5 | 300.0 |
EssentialID | LabID | Category | Description | Laboratory_Essentials | Date_of_purchase |
---|---|---|---|---|---|
(→ Laboratories.LabID) | |||||
1 | 1 | Lab Equipment | Glassware and chemicals | Flasks, Beakers, Test Tubes, etc. | January 2023 |
2 | 1 | Lab Equipment | Scientific instruments | Microscopes, Balances, Spectrophotometers, etc. | February 2023 |
3 | 1 | Safety Gear | Personal protective equipment | Gloves, Safety goggles, Lab coats, etc. | January 2023 |
4 | 2 | Lab Equipment | Computers and peripherals | Desktops, Monitors, Keyboards, etc. | March 2023 |
5 | 3 | Safety Gear | Fire prevention and control equipment | Fire extinguishers, Fire blankets, Smoke detectors, etc. | April 2023 |