2025
Online Retail Database System
Designed and implemented a relational database for an online retail system using SQL Server, including ER modelling, table creation, data population, and analytical queries.
What Is It
A relational database system simulating operations of a beauty retail business.
What Have I Done
Designed ER diagrams, implemented relational tables, and created SQL queries for business analysis.
Tools/Skills
1) SQL
2) Database Design
3) ER Modelling
4)Microsoft SQL Server
Outcome/ What it shows
Demonstrates my understanding of structured data, database integrity, and analytical queries.
Overview & Objectives
This project involved designing and implementing a relational database for a beauty retail shop, simulating real-world operations such as product sales, customer purchases, supplier management, deliveries, and customer feedback.
I analysed the business requirements and designed an entity-relationship (ER) model representing customers, beauty products, categories, suppliers, purchases, deliveries, and item ratings. The ER design was translated into relational tables using Microsoft SQL Server, with appropriate primary and foreign key constraints to maintain data integrity.
Demonstrates my ability to design and implement a structured relational database using SQL Server, ensuring data integrity and enabling efficient querying to support operational and analytical requirements in a retail system.
