This was my CPSC 471 group project. We had to create a prototype for an application that we chose. The project was focused on doing user research, ideation, design, prototyping and evaluating. The project is a clubs and events search application for the University of Calgary. I received an A- for the project. Note: Not actually affiliated with the University of Calgary at all.

We had to find an interesting scenario where we could implement a database system. We thought that something based off of real life would be really great to make. We realised the the University of Calgary's Student Union Food Bank realises on a lot of documented paper and filling it manually. We thought that they could definitely benefit from a computerised system.

We had to design how our database would connect and how the data would flow. We also had to design our SQL queries for setting and getting the data. Additionally, we had to make a front end for the end-users to use the system, which was a website. We wanted to make the website as straight forward as possible, hence having clear buttons for instructions.

Initially, we were going to implement it using PHP and MySQL, but we decided in the end to use the Flask library from Python with SQLite3. The database stores user account information which has access level for the website, admins being able to see more features than the clients.

We could have written more complex SQL queries to improve the connectivity of our database, but what we had was sufficient enough.