Hogwarts Registrar is a web app that showcases relational databases and allows the user to add, delete, and update data in the system. It utilizes many to many relationships and many to one relationships to generate and update data.
It was designed using Python, Flask, and MySQL in the backend, and Bootstrap and Javascript for the UI.
It was developed by Melissa Lagunas and Nishant Tharani in the Fall of 2020 for the Introduction to Database course at Oregon State University.
The following functionality is implemented:
- User can add entries to the following tables: Students, Instructors, Classes, Houses, and Enrollments.
- User can delete entries from the following tables: Students, Instructors, Classes, and Enrollments. (Houses excluded, because Hogwarts Houses will always exist. 😃)
- User can update entries from the following tables: Houses, Instructors
- Website has an intersection table: Enrollments, where students can be 'enrolled' in a class.