| StudentID | FirstName | LastName | DateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 1990-01-01 |
| 2 | Jane | Smith | 1987-02-15 |
| 3 | Michael | Johnson | 1992-03-20 |
| 4 | Emily | Williams | 1996-04-10 |
| 5 | David | Brown | 1989-05-25 |
| ClassID | ClassName |
|---|---|
| 1 | Sustainability Project |
| 2 | Robotics |
| 3 | Automation |
| 4 | Material Science |
| 5 | Electronics |
| ClassID | ClassName |
|---|---|
| 1 | Sustainable Architecture |
| 2 | Urban Planning |
| 3 | Graphic Design |
| 4 | Product Design |
| 5 | Industrial Design |
| ProjectID | ProjectName | EngineeringClassId | DesignClassId |
|---|---|---|---|
| (→ EngineeringClasses.ClassID) | (→ DesignClasses.ClassID) | ||
| 1 | Green Building | 1 | 1 |
| 2 | Autonomous Vehicle | 2 | 3 |
| 3 | Waste Management System | 3 | 4 |
| 4 | Smart Home Devices | 4 | 2 |
| 5 | Nanotechnology Applications | 5 | 5 |
| StudentID | ProjectID | Grade |
|---|---|---|
| (→ Students.StudentID) | (→ Projects.ProjectID) | |
| 1 | 1 | A+ |
| 2 | 2 | B+ |
| 3 | 3 | C+ |
| 4 | 4 | A |
| 5 | 5 | B |
| StudentID | EngineeringClassId | DesignClassId |
|---|---|---|
| (→ Students.StudentID) | (→ EngineeringClasses.ClassID) | (→ DesignClasses.ClassID) |
| 1 | 1 | 1 |
| 2 | 2 | 3 |
| 3 | 3 | 4 |
| 4 | 4 | 2 |
| 5 | 5 | 5 |