As a group leader, my role is to ensure that we as a group had a clear path on the project and implemented it maximally. I also made sure that everyone feels comfortable in contributing to the group based on their interest and expertise.

Other than that these are my contributions for my group project:

Backend

I was responsible for almost everything related to backend. I made the backend based on our groups Database Diagram (ERD) with Django. I also made sure that the website is capable in doing CRUD operations (Create, Read, Update, and Delete) effectively and fast. This requires structuring the code well, avoiding repeated codes, and various different techniques.

Development Environment

I also helped my team in setting up the development environment for frontend and backend for all of my friends. This requires installing python package management control (PIP) and the required library used by the website for the backend. For frontend this requires installing gulp and its packages for live reloading and bootstrap integration. I also made the repository of the project at github to make our group teamwork easier.

Database Checking and Validation

Database checking and validation was also one of my contribution for my team. I validated and checked the database ERD and structure to make sure its in 3NF form. This is crucial because without being 3NF the website could not be as good as todays website standard.

View Report as PDF in Browser

To view the report as PDF in current browser simply press the View button below 😀

What is Velgbro?

Velgbro is a platform where people who are in need of a wheel can access, buy or even sell a wheel.

With VelgBro people can find wheels based on their specific needs such as ringsize, offset, and more. People can also post wheels that they wish to sell and find potential buyers. In other words this platform is a combination of OLX and Tokopedie, where people connect for a potential buy or sell of their wheels. By that the website serves based on the CRUD theory where user can Create, Read, Update, and Delete wheels to the website.

Goals

1. To create a website that able to store the data of the product in a database using Mysql and having a complex schema in our database.
2. Making sure it covers all the range of basic and advanced queries in Mysql.
3. Provide a reliable platform for car enthusiast to sell and buy car parts.
4. Have a normalized database that is sufficient in handling moderate number of requests.
5. Create a website that is qualified as a professional website.

External Libraries

Writing everything from scratch these days is not effective so I decided to use various external libraries.

For front-end this website uses bootstrap, premade css and js templates. With these libraries the front-end development will take way less time than using vanilla or pure front-end. And since this is a Database Course I think it’s better to spend time writing the backend and the database.

For backend I decided to use Django because I’m familiar with Python and the experience I got from previous projects. For the database I connected MySQL from XAMPP with Django manually. I decided to use XAMPP so it’s easier to inspect the database and set up.

Why Velgbro?

This website is inspired by one of my group members experience where he was in need of a wheel but cant find a clear platform for it. Finding wheels these days is a problem (especially used wheels), there is no platform where people can find new or used wheel based on their very specific needs. That’s why I decided to create this website to fill in the gap and since it also has potential for further expanding in the future if wanted