Retail Store Database Design using SQL Server

This project involves designing and implementing a complete database system for a retail store using SQL Server. The goal is to efficiently manage and organize store data while ensuring data integrity and relational consistency.

Key features of the project:

Analysis of system requirements and identification of key entities

Designing tables following best practices in Data Modeling

Defining Primary Keys and Foreign Keys to maintain proper relationships

Applying constraints such as NOT NULL and CHECK to ensure data validity

Organizing relationships between Customers, Products, Categories, Brands, Orders, and Staff

Inserting Sample Data to test database functionality

Creating a Database Diagram illustrating the relationships among tables

Technologies and concepts used:

SQL Server

T-SQL for table creation and queries

Relational Database Design

Normalization

Data Modeling

This project demonstrates practical skills in database design and relational modeling, and it is fully extendable to support real-world retail operations.