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.

DQL Script

This script retrieves meaningful insights from the database using SELECT queries.