Project

University Database System.


Front-End: HTML, CSS, JavaScript
Back-End: Python, SQL
Frameworks & Tools: Flask, AWS, mySQL, BootStrap, GitHub

Project Duration: 8 weeks
Project Team Size: 4


I developed the front-end and back-end for a university database system. This database system supports two main parts in its functionality. The first part is that new students can apply to this university through a portal and must go through the transcript review, recommendation letter process, and other standard processes that occurs in a college application process. The second part of this system is that current students are able to log in and register for courses, check their transcript, drop classes, and change personal information. Faculty are also able to log in through the same portal and submit grades for students and check transcripts of their students.

The data is stored in SQL tables, which is accessed through the mySQL system. For the routing of different pages in the portal, the Python Flask framework was used. For front-end development, BootStrap was utilized to create clean and uniform styles through the different pages. GitHub was used to manage the workflow among three other team members. Finally, the website itself was hosted on an AWS instance. This project allowed me to gain more experience in full-stack development and learn how to develop programs within a team.