## Students

ID | FirstName | LastName | GradeLevel
--- | --- | --- | ---
1 | John | Doe | 10
2 | Jane | Smith | 9
3 | Emily | Brown | 8
4 | Michael | Johnson | 12
5 | Sarah | White | 7

## Teachers

ID | FirstName | LastName | SubjectTaught
--- | --- | --- | ---
1 | Mr. | Smith | Math
2 | Ms. | Williams | English
3 | Dr. | Harris | History
4 | Mrs. | Davis | Science
5 | Mr. | Martinez | Art

## Classrooms

ID | RoomNumber | Building | Capacity
--- | --- | --- | ---
1 | 101 | Main | 30
2 | 201 | Annex | 25
3 | 301 | Main | 35
4 | 401 | Annex | 20
5 | 501 | Library | 60

## Textbooks_Supplies_Projects

ID | TextbookTitle | SupplyItem | ProjectDescription
--- | --- | --- | ---
1 | To Kill a Mockingbird | Poster paper | Create a poster about the novel
2 | The Great Gatsby | Pencils | Write a short story inspired by the book
3 | A Wrinkle in Time | Markers | Draw a map from the book
4 | Romeo and Juliet | Glue sticks | Make a collage about the play
5 | Of Mice and Men | Index cards | Create flashcards to memorize quotes

## Assignments

ID | Title | Description | DueDate | MaxPoints
--- | --- | --- | --- | ---
1 | Vocabulary Quiz | Test your knowledge of vocabulary words learned this week | 2023-03-15 | 50
2 | Research Paper | Write a research paper on a topic related to our current textbook | 2023-04-10 | 100
3 | Creative Writing | Write a short story based on a scene from a textbook | 2023-03-25 | 80
4 | Group Presentation | Present a group project on a topic related to the unit | 2023-04-15 | 100
5 | Final Exam | Review all material covered during the unit | 2023-04-20 | 100

## Grades

ID | StudentID | AssignmentID | Score | Feedback
--- | --- | --- | --- | ---
| (→ Students.ID) | (→ Assignments.ID) |  |
1 | 1 | 1 | 45 | Good effort but needs improvement
2 | 2 | 1 | 60 | Great job! Keep up the good work
3 | 3 | 1 | 75 | Excellent work! Very well done
4 | 4 | 1 | 85 | Outstanding performance! Well done
5 | 5 | 1 | 90 | Exceptional work! You excelled at this assignment