🚲 SQL Analysis – Bicycle Store
This project demonstrates the full cycle of a database solution for a retail bicycle store, including:
- Database Design
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
📘 Entity-Relationship Model
The ER model outlines relationships between customers, bicycles, suppliers, employees, and repair orders.
📄 DDL Script
The DDL script defines tables and constraints used to implement the database.
📥 Download DDL Script📄 DQL Script
This script retrieves meaningful insights from the database using SELECT queries.
📥 Download DQL Script