Database : PC Parts Picker

PC Part Picker ( Premade – Rental )


The topic of our project will be PC part pickers. Our group has three members: Raphael, Rohan, Ardelia. We intend to create a database that contains items organized by category, such as VGA, Monitor, Processor, Motherboard, and so on. Other than that, we create databases for the customer details, product delivery and order transaction. The customer can choose the parts based on the categories, receive an estimate of how much they will spend. Finally, make an inventory to update, add and delete products. 

ERD Diagram

Layout of our program

Sign up page where customer enter their details
After sign up the customer is redirected to sign in
After sign in the customer is directed to the main menu where customer can select their desired pc parts and see the total price

Members’ Contributions 

  1. Sri Kalyan Rohan – ERD and Backend ( SQL)
  2. Ardelia Shaula Araminta : Front end ( Signing up and in , Billing and Payment , Database Connection)
  3. Raphael Reynaldi : ERD and Front end (Inventory)

Self Contribution

The theme for our database project was about PC Parts Picker that is useful for those who are in need of buying the pc parts without hassle. Unlike other sites, its compatibility tool that ensures all your parts will work together or if any issues need to be resolved and also all in one go shopping. My teammates and I divided our work load to ease the workflow of our project. We decided to divide into two parts: backend and front end. The back end works to ensure that all the queries in the database can be accessed from the front end while the front end visualized the desired design or UI/UX that we initially discussed as shown below.

The project’s front end was my responsibility. I began creating the sign-up and sign-in forms, as well as connecting them to our database. Then I focused on the main menu, which is where the customer may select and check out their preferred computer parts. I was having trouble implementing the concept at first, but after a few days, I was able to come up with a solution. At the end I managed to finished what i was visioning in my head. In conclusion, the project has taught me a number of lessons, including the need of being organized when working on a project, the fact that there were many occasions when I felt like giving up, but I persisted and remained positive. But, after witnessing how the game turned out as planned, I’m extremely happy and pleased of the final result, and it was all worth it. I’m also glad to my teammates who was willing to cooperate. 

Link to Github : https://github.com/ardeliaraminta/db_pcparts