This project simulates a small retail order management system built using SQL Server. It demonstrates database design, data integrity, analytical querying, and reporting through views.
The project is intended to showcase core SQL skills relevant to a Junior SQL / Database Developer role.
- Normalized relational database design
- Entity Relationship Diagram (ERD)
- Referential integrity using foreign keys
- Constraints to enforce business rules
- Multi-table JOIN queries
- Aggregations and grouping
- Subqueries and CTEs
- Business-focused analytical questions
The project includes SQL views that provide:
- Order financial summaries
- Customer lifetime value analysis
- Product sales performance
- Employee sales performance
- Identification of pending and problematic orders
- SQL Server 2022
- SQL Server Management Studio (SSMS)
- Git & GitHub
This project is currently in progress.
- Database schema
- ERD
- Sample data
- Analytical queries
- Views
- Stored procedures
- Triggers
- Indexes
- Performance optimization
schema/ – table creation scripts data/ – sample data inserts erd/ – entity relationship diagram queries/ – analytical queries views/ – reporting views
Project requirements and design decisions are documented separately.