- Tables:
Students (StudentID, Name, Class, Section)
Subjects (SubjectID, Name)
Marks (MarkID, StudentID, SubjectID, MarksObtained)
- Queries you can write:
- Find top student in each class.
- Calculate average marks in each subject.
- Show pass/fail students.
Leave a Reply