Introduction

For a database systems course, my team and I designed and modelled relational entities for a social media application. Then, we implemented them.

Using PostgreSQL and React, my team and I created a full-stack social media platform for plant enthusiasts to get together and share their passions.

Application Demo

Deployed Website

Process

Our team used notion.io to keep track of relevant resources on PostgresSQL, React as well as ER diagrams, and design schemas.

Once we nailed down our design based on the requirements of our project and the particularities of our idea, I translated our ER diagrams into relational schemas for implementation.

The majority of the project was spent on implementation of the entire applications post-design phase. We chose PostgreSQL and React as relevant technologies to try and learn and successfully implemented our application.

Implementation Demo

Strategy, Git and Code Reviews

Throughout the process we would test each other's code using git to track and pull requests for review and feedback.

We had weekly meetings where we would discuss, priotized, and set milestones for ourselves. Additionally we held an optional group coding session once a week to promote collaboration and move the project forward efficiently.

Role

My role in the team was simply contributor in terms of development. I also worked on modelling most of the entities.

In the early stages I was in charge of designing and translating the idea from the ER diagrams to the relational models with iteration sessions and feedback with the team. As a group we then implemented the application. Specific features and back-end structures I contributed are the entire profile page and it’s subcomponents, the about page, the tagging feature and portions user-controller and post-controller related to my front-end features.

Project Outcomes

This project was very important in my growth and understanding of systems design while also being my first experience with SQL.

In one project I was exposed to git, database design, database implementation and front-end implementation using the most relevant technologies of the time. In the end we produced an exceptional implementation of a full-stack application in the time we were given.