Senior Project - March 2024
E-commerce Database Management System: Consolidating Buyer Data using SQL
Scroll ↓
Overview
Using SQL, we aimed to streamline the process of e-commerce data management. Our database makes it easy for Sellers to enabling businesses to gain insights into customer trends, manage customer data efficiently, and improve order fulfillment accuracy.
Use
Manage Customer Data: Provides a scalable and editable database that stores customer information.
Consolidate Buyer Input Data: Centralizing data from multiple sources into one structured database, making it easier to manage and access.
Order Fulfillment: Providing real-time data access to sellers for improved order accuracy and customer satisfaction.
Analyze Customer Trends: Through queries, we are able to parse through the data to identify any potential market opportunities such as purchasing patterns or customer demographic similarities.
Why did I make this?
In order to hone my skills in the language of SQL, specifically MySQL as the database management system, I decided to recreate how a database would work for storing buyer information for an online store. This project had me use many of SQL’s fundamental functions including creating and managing tables, executing queries to insert, update, and retrieve data, and establishing relationships between different data entities through primary and foreign keys. Beyond the basics, I delved into more complex operations such as writing stored procedures and optimizing queries for efficiency. This hands-on experience allowed me to deeply understand how relational databases can be structured and manipulated to support the backend of an e-commerce platform, providing valuable insights into data management and application development. By tackling this project, I not only solidified my proficiency in SQL but also gained practical experience in database design and optimization, making me better prepared for future challenges in data-driven environments.