## Students

id | firstName | lastName | major | yearInSchool
--- | --- | --- | --- | ---
1 | John | Doe | Computer Science | 3
2 | Jane | Smith | Electrical Engineering | 2
3 | Alice | Brown | Mechanical Engineering | 4
4 | Michael | White | Civil Engineering | 3
5 | Emily | Black | Aerospace Engineering | 2

## Classes

classId | className | professorName | roomNumber | capacity | timeSlot
--- | --- | --- | --- | --- | ---
1 | Introduction to Computer Science | Dr. Johnson | Room 101 | 30 | 9:00 AM - 11:00 AM
2 | Electronic Circuits | Prof. Smith | Room 202 | 28 | 11:30 AM - 1:30 PM
3 | Fluid Mechanics | Dr. Brown | Room 303 | 35 | 2:00 PM - 4:00 PM
4 | Structural Analysis | Prof. White | Room 404 | 32 | 4:30 PM - 6:30 PM
5 | Material Science | Dr. Black | Room 505 | 27 | 7:00 PM - 9:00 PM

## Enrollments

enrollmentId | studentId | classId | grade
--- | --- | --- | ---
| (→ Students.id) | (→ Classes.classId) |
1 | 1 | 1 | A
2 | 2 | 2 | B+
3 | 3 | 3 | A-
4 | 4 | 4 | B
5 | 5 | 5 | A

## Projects

projectId | title | description | dueDate | status
--- | --- | --- | --- | ---
1 | Optimizing Algorithms | Research on improving sorting algorithms. | 2023-05-15 | Not Started
2 | Renewable Energy Storage | Exploring energy storage solutions for renewable sources. | 2023-05-20 | In Progress
3 | Urban Transportation Systems | Designing efficient transportation systems for urban areas. | 2023-05-25 | Completed
4 | Nanotechnology Applications | Investigating potential applications of nanotechnology in various fields. | 2023-05-30 | Pending Review
5 | Artificial Intelligence Ethics | Examining ethical considerations of AI and its impact on society. | 2023-06-05 | Not Started

## Theme_Tracks

themeTrackId | themeTrack | submissionTopic | conference | abstract | fullPaper
--- | --- | --- | --- | --- | ---
1 | Machine Learning | Deep learning techniques for natural language processing. | International Conference on Artificial Intelligence | This paper presents a novel approach to NLP... | The full paper can be found at https://example.com/fullpaper.pdf
2 | Robotics | Swarm robotics for environmental monitoring. | Annual Robotics Symposium | We propose an innovative swarm robotic system for monitoring... | https://example.com/fullpaper_robotics.pdf
3 | Green Technologies | Carbon capture and storage using machine learning. | Global Climate Summit | Our research focuses on developing ML models for CCS... | https://example.com/fullpaper_green.pdf
4 | Healthcare | Wearable devices for continuous glucose monitoring. | World Health Congress | This study investigates the effectiveness of wearables in continuously monitoring... | https://example.com/fullpaper_healthcare.pdf
5 | Space Exploration | Advanced propulsion systems for interstellar travel. | Interplanetary Conference | This paper explores recent breakthroughs in propulsion technology... | https://example.com/fullpaper_space.pdf

## Submissions

submissionId | studentId | themeTrackId | projectId | dateOfSubmission | feedback | grade
--- | --- | --- | --- | --- | --- | ---
| (→ Students.id) | (→ Theme_Tracks.themeTrackId) | (→ Projects.projectId) |  |  |
1 | 1 | 1 | 1 | 2023-04-15 10:00:00 | Well done! Consider focusing more on practical implementation. | A
2 | 2 | 2 | 2 | 2023-04-20 10:00:00 | Good job! More work is needed on the theoretical aspects. | B
3 | 3 | 3 | 3 | 2023-04-25 10:00:00 | Great effort! The literature review could be improved further. | A-
4 | 4 | 4 | 4 | 2023-05-05 10:00:00 | Needs improvement. Focus on addressing the problem statement more clearly. | C
5 | 5 | 5 | 5 | 2023-05-10 10:00:00 | Very well written! Some minor revisions are suggested before final submission. | A