Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe1990-01-01
2JaneSmith1987-02-15
3MichaelJohnson1992-03-20
4EmilyWilliams1996-04-10
5DavidBrown1989-05-25

EngineeringClasses

ClassIDClassName
1Sustainability Project
2Robotics
3Automation
4Material Science
5Electronics

DesignClasses

ClassIDClassName
1Sustainable Architecture
2Urban Planning
3Graphic Design
4Product Design
5Industrial Design

Projects

ProjectIDProjectNameEngineeringClassIdDesignClassId
(→ EngineeringClasses.ClassID)(→ DesignClasses.ClassID)
1Green Building11
2Autonomous Vehicle23
3Waste Management System34
4Smart Home Devices42
5Nanotechnology Applications55

EnrolledStudents

StudentIDProjectIDGrade
(→ Students.StudentID)(→ Projects.ProjectID)
11A+
22B+
33C+
44A
55B

CourseEnrollments

StudentIDEngineeringClassIdDesignClassId
(→ Students.StudentID)(→ EngineeringClasses.ClassID)(→ DesignClasses.ClassID)
111
223
334
442
555