Loading Project...
Minecraft DB
Database Modeling Project
This project focused on creating my first Entity Relationship Diagram (ERD) for Minecraft using MySQL to model key entities like players, items, and skins, while exploring relational database design principles and normalization techniques.
Project Overview
This solo project involved creating my first Entity Relationship Diagram (ERD) for the game Minecraft. I used MySQL to model essential game entities such as players, items, and skins to explore relational database design, normalization principles, and entity relationships in a gaming context.
Design Process
ERD Creation
Designed an ERD to capture relationships between Minecraft entities like players, items, and skins with proper cardinality.
MySQL Implementation
Used MySQL to model and implement the database structure with proper foreign keys and relationships.
Relational Design
Explored relational database concepts like normalization, primary keys, and entity relationships.
Database Stack
Implementation Details
MySQL Tables
MySQL table structures showing the normalized database design with proper relationships between players, items, and skins. Demonstrates understanding of primary keys, foreign keys, and data types.
SQL Inserts
MySQL insert statements populating the database with Minecraft game data. Shows practical implementation of the database design with realistic game entities and their relationships.
Skills Unlocked
Database Fundamentals
Solid understanding of relational databases and representing real-world entities through ERDs
MySQL Mastery
Hands-on experience with MySQL database implementation and SQL query writing
Data Normalization
Key database design concepts like normalization and relationships between data entities