This project focuses on designing and analyzing an e-commerce database using SQL. Data generated with AI prompt. It includes database schema creation, data insertion, and analytical queries. The final stage has VIEWS for 5 different stakeholders roles.
- Database schema design
- Sample data insertion
- Analytical queries
- Common Table Expressions (CTEs)
- Views for Stakeholders reporting
- SQL (CTEs, Views, Joins)
- Relational Database Concepts
- AI prompts for random data values
/data: SQL script with all the inserts , generated by AI/docs: tha final presentation in pdf file/queries: SQL queries for Basic analysis, CTEs and views for each stakeholder/schema: SQL script for database and tables creation
- Designing relational schemas
- Writing analytical SQL queries
- Using CTEs and views for cleaner analysis
©️ 2026 Periklis Andrianos