What is this project?
In our 370 class, we were asked to create a project to represent an Amazon-like database. It needs to show all the payments when we enter the csv files, including order number, customer ID, shipping address, etc.
This was a cool project because it was not just our first time working with MySQL, but also to see how the database works. We created 3 sets of data, each with different connections:
For the first set, we focused mostly on the details of the shopping cart. How many items do they buy? How much is the cost of each item? What is the total amount?
For the second set, we focused more on customer rating on the item, where they can be found.
For the last set, we focused on our customers' contacts, their emails, phone numbers, payment methods, etc.
We also learned to create a user-friendly display using PHP. Overall, it was fun and I defenitely look forward to creating another project like this in the future.
Those dataset can be found in our individual branch on our Github link that I attach below:
Contact Me
Get in touch for inquiries and collaborations.