Daily Archives: January 26, 2022

Database Project Proposal

PC Part Picker ( Premade – Rental )
The topic of our project will be PC part pickers. 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. We decided to use mySQL.

Our group members:

  • Sri Kalyan Rohan
  • Ardelia Shaula Araminta
  • Raphael Reynaldi

Our project has the need to develop a database that will include Customers ( Customers Login and Sign up), Orders Transactions, Staff (Staff Login), Products, Category of Products, Manufacturers. As shown in teh ERD diagram below:

ERD Diagram

Objectives of our project:

  • Manage sign up and login of customers ( update the database )
  • Login staff to allow access to Inventory
  • Inventory (  item update that would allow us to delete and add more items , and search items)
  • Shopping cart and billing system ( payment )