In Notre Dame’s Database Systems (CSE 30246) course, I worked in a group of three to develop CourseCrafter, a tool designed for class schedule organization and recommendation. This application helps users to construct their academic plans, accommodating various majors, minors, and concentrations. Its key feature is the real-time update of course prerequisites, corequisites, and credit requirements, which adds a dynamic aspect to academic planning. CourseCrafter also supports saving multiple schedules.

We integrated two main features into CourseCrafter: a user-friendly Schedule Planner with a drag-and-drop interface, and a Course Ratings system for users to rate and review classes. The Schedule Planner allows for straightforward organization of courses, while the Course Ratings system utilizes SQL queries to average ratings and compile common course statistics.

CourseCrafter was initially deployed on Heroku, featuring a React/Next.js frontend and a Flask backend, with the MySQL database hosted on AWS.

Currently, the website not operational due to cost factors. However, the project’s code is available on GitHub: frontend code and backend code. Additionally, for a more comprehensive understanding of CourseCrafter, a video tutorial can be viewed by clicking on the image below.