Senior Project - March 2024
E-commerce Database Management System: Consolidating Buyer Data using SQL
Scroll ↓
Overview
I took a course called Information Systems in which I was first introduced to relational databases through Microsoft Access. I was highly intrigued by the potential of database management systems and their relative ease of use over coding languages. Due to this interest, for my Senior Project I decided to take a deeper dive into database management through SQL. I started off my project by completing a 50+ hour certification course where I learned the fundamentals of using SQL. I also wanted to create a mini project to display what I had learned form achieving my SQL certification. After much brainstorming and research, I decided to make a database system which would management buyer data in online stores. My 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.