This project highlights my database design and querying skills using MySQL.
- Database Schema: Designed based on a template from drawSQL, then customized for this project.
- Schema Design: Built tables with primary/foreign keys, constraints, and relationships.
- CRUD Operations: Practiced inserting, reading, updating, and deleting data.
- SQL Queries: Wrote queries for filtering, aggregation, joins, and data manipulation.
- Advanced Features: Implemented triggers, events, etc.
- Schema adapted from a drawSQL template and tailored to project needs.
- Fully normalized tables for scalability and structured data storage.
- Practical SQL queries covering different relational database concepts.
- Database: MySQL
- Schema Reference: drawSQL templates