Individual database project + web adaptation Local demonstration
University Grading System
The application brings students, courses, faculty, enrollments, grade entry, and reports together in a local Python/SQLite demo.
A closer look.
Select a screen to explore the details.
Project details.
Project overview
Explore academic data relationships and make grade-recording and reporting workflows easier to inspect. The supplied package maps a 2024 SQL case study to a later browser application. The displayed student and faculty data is fictional.
My contributions
I designed the original academic database, wrote SQL queries, modeled relationships, and implemented the grading logic. The later web adaptation makes those concepts available through a browser interface.
- Student, course, faculty, and enrollment management.
- Grade recording using non-overlapping grade bands from the SQL source.
- Printable report cards, academic summaries, and grade exports.
Outcome & learning
Local demonstration with fictional students. The supplied package does not include production authentication or a verified public repository link. Conflicting grade-band descriptions need an explicit source of truth. This adaptation follows the non-overlapping SQL bands and documents that choice.
Kiesha Conde