The problem Course Allocation System solves

Earlier, Audit/Elective Courses were allocated manually and registrations were obtained from a Google form and then a student was alloted a particular course after checking his/her preferences and availability of a Course. This was a tedious and time-consuming process for the College Authorities. Hence, to solve this issue, a Web Application known as Course Allocation System was developed, which would serve as a portal for smooth management of the Courses, thereby making the process easier by automating the Allocation using Python. Also, a MySQL database was maintained to store the Courses data and the responses and Faculty details as well. User-Interface was developed in such a way that different screen was shown for various login roles, for example: Institutional Coordinator will have access to all the important features on the portal, but any authority below that level will not have access to the important features and lesser number of functionalities will be provided as one moves down the levels. Institutional Coordinator can create a new course, add/modify faculty or student details records, float a form for registration, view activity logs, Allocation statistics and a PDF will be generated containing the Allocation results along with a few other minor functionalities.

Challenges I ran into

It was a bit difficult to design the structure of such a huge MySQL database and maintain it from time to time, making sure the entries were consistent and provide dynamic updation and facilities of creating a new course without having to separately create new tables for it. Another hurdle was implementing restrictions according to various login roles and maintaining security for the important features but it was successfully implemented with the help of PHP by checking the login role at the time of Login.