MySQL Projects

Overview

A collection of MySQL database projects and assignments demonstrating my skills in relational schema design, query writing, and data analysis.

Contents

• EXAM 1 – SQL scripts and solutions from a course exam. Includes creating tables, populating data, and writing analytical queries.
• P3 Submission – Capstone project: designing a normalized schema for an e‑commerce dataset, with stored procedures and triggers.
• Vehicles homework – Practice with JOINs and subqueries using a vehicle-ownership dataset.
• flight – Flight-booking schema and sample queries. Includes ERD and CSV seed data.

How to Use

1. Install MySQL (version 8+).
2. From the command line, run scripts in each folder:

   mysql -u youruser -p < flight/flight_mysql_dump.sql

3. Explore the provided .sql files to understand the schema and queries.

Professional Value

These projects illustrate my ability to:

• Design normalized schemas and convert requirements into SQL.
• Write complex queries involving JOINs, aggregation, and subqueries.
• Use stored procedures and triggers for application logic within the database.