Introduction

Executive summary

Modifying cars are the most common thing where car lovers usually do. They usually modify their cars based on specific requirements that the car can fit. That will make car wheels really famous in the car lovers’ world because modifying their wheels are one of the dreams that car enthusiast usually do as it can be one of their pride to be shown among their friends.

As we all discussed about what to do in our final project, our group are discussing about cars as most of our team members are car enthusiast which really like to modify their cars and understand a lot about cars. Due to that, we agreed on selling car wheels as there are no e commerce which specifically sells car wheels in Indonesia which is our agreement.

Based on many examples of e-commerce, we had some inspirations from OLX, mobil123, and fitment industries to make our project. There are lots of discussions among the team members to know what we should make and what we should insert in our final project so that we could exceed the minimum requirements that was required from the rubric. Furthermore, there are lots of functions that is based on the sql queries that we need to make and we try to have different types of cardinalities in order to make the database ordered and easier to be sorted.

What is Velgbro?

Velgbro is a website which sells car wheels with all of the specifications that is needed to search for car wheel easily and as the customer wanted. The customer will enjoy a spectacular time at using our website which they can customized their wheel with their own preferences without limiting any products of wheels.

A website which could sell, buy, or even updating your data will be one of your preference in searching car wheel. You can check products easily and contact the seller by contacting their phone number by using whatsapp and there are text that is set automatically from the website which eases the user to send the message.

GOALS

1. To create a website which uses mysql database in doing the search, update, or add post in the website.
2. To have a reliable database with different cardinalities which will be used for the website.
3. To provide information related to car wheel which eases the customer to buy or search or sell.
4. Learning new queries for doing functions in the website.
5. Create a website which is qualified to be shown to people.

External libraries

Django is the framework that we used while making our website for the back end program because it is secured and it is connected to MySQL as well. Django uses its own syntax to make the sql queries so it simplify our work in doing our project.

For the front-end I will be using bootstrap, a premade CSS and JS library that will ease the work for the front-end developer. By using the CSS and JS library, it makes us more focus on the database rather than the front end.

Why Create Velgbro?

We choose to create velgbro for our final project because we wanted to learn more on making a website with a database backend to store the data. By learning how to make professional website, we learned lots of things starting from learning on the frameworks until the front end which is the visual of the website. Furthermore, to know more about the security of a website and experiencing having a website which could sell a product as a practice even though it is not real yet as it doesn’t have its own domain.

As our team had agreed on making the website about car wheels, we got to study more about wheels as well and the type and parts of wheel on cars as well. However, the main thing that we can gain more on is the database queries that we did not know before and how to make a good front end.

In this project, my team has shared the work within the group members and all of the group members had worked really hard to accomplish this project. I, as the team’s database designer, helped my team by discussing the database and designed it in form of a Entity Relation Diagram which made it easier for my team to create the website that we made.

ERD and Cardinalities

I made the ERD with the cardinalities and attributes that is required from the requirements on the rubric that was posted. I make the ERD with different types of relationships which are the one to one, one to many, and many to many relationships. Also, all of the attributes with its data types have been shown in the ERD.

Few function on the backend

I helped my teammate to do some of the function on the backend which are updating the profile, changing the password, updating the post, and deleting the post itself.

Report

Then, I made most of the report as I know most about the database and the tables that I created so I know about the entities, relations, and normalisation of our team’s database.

Due to the great teamwork of our team, we managed to create the website for our project with the database and functions which is our main goal since we showed our proposal for the first time.