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 |