This project represents a relational database for a barbershop management system. This project demonstrates practical SQL skills for data analysis and database design.
The database was designed and implemented from scratch using SQL Server. Synthetic data was generated to simulate real-world usage.
- Design relational database
- Implement business logic using SQL
- Optimize queries with indexes
- Perform business analytics
- SQL Server
- T-SQL
- Designed normalized relational database
- Implemented many-to-many relationships
- Created stored procedures for business logic
- Used triggers for data validation
- Built analytical queries for business insights
- schema/
- data/
- logic/
- analytics/
Main entities:
- Barbers
- Clients
- Services
- Appointments
- Visit Archive
- Feedback
- Primary & Foreign Keys
- Stored Procedures
- Views
- Triggers
- Indexes (filtered, include)
- Top barbers by revenue
- Most popular services
- Average check
- Customer retention
- Workload analysis
Run scripts in order:
- create_tables.sql
- indexes.sql
- insert_data.sql
- procedures.sql
- views.sql
- triggers.sql
- business_queries.sql
- Data is randomly generated
Dmytro