COSC 304 - SQL Enabled Shopfront


Project Type: Group
Purpose: Class Project
Programming Language: SQL, Java, JavaScript, HTML
GitHub Link: Click Here

Project Description

This project was created as part of a requirement for the class. Our group was tasked with creating an online shopfront similar to Amazon that utilized SQL to handle the database information. In addition to this, we used JSP and Tomcat to help hook up the website to the database.


Roles & Responsibilities

Group Roles
Overall Project Management
Backend Development
Frontend Development

Group Responsibilities
Delegating project work
Writing most of the CSS
Writing a majority of the backend code
Creating the project demo video
Finidng and fixing bugs within the system

Group Contribution

For this project, I ended up contributing most of the work. Out of the ~21 JSP files, I worked on 10 files alone and improved/assisted with the other 11 JSP files. In addition to that, I created the original DDL (SQL Database File) and also wrote almost all the CSS for this project. Near the end of the project, I went through each page and feature to do a final QA test to ensure that the system was functioning as expected. I found ~4 major bugs and fixed them before making the project demo video.


I just wanted to mention as well that I am aware of the poor CSS structure throughout the project. Initially, we didn't expect that the project would get so large and complicated, so we went with CSS in each page, as opposed to just using CSS files. This was one of the biggest mistakes I was part of for this entire project, and definitely something that I have improved on since. I think the CSS structure on this website isn't perfect, but it is much better than what I have done in the past.


Solo Work

If you visited the GitHub link for this project, you probably noticed that it was posted on July 23rd, 2022. This was because the project wasn't originally developed on GitHub, so I had to import it to GitHub long after the project was completed. We didn't start this project on GitHub since we didn't realize how much work would be involved.