School Project

SQL Databse Design

Designed and implemented an SQL database for Cal Poly Survivor, tracking participants and game stats per episode and season for efficient data management.

Pink Flower
Pink Flower

Location

Location

San Luis Obispo
San Luis Obispo

Position

Position

Team Leader
Team Leader

SQL Database Project for Cal Poly Survivor

During my BUS 393 Database Design class at Cal Poly, I collaborated with a team to design and implement a comprehensive SQL database for Cal Poly Survivor, a student organization I founded. This database was pivotal in tracking and managing all participants and their game stats across each episode and season.

Conceptual Design:
We began with the conceptual design phase, where we defined the entities and relationships necessary to capture the structure of the game. This included identifying key entities such as Participants, Episodes, and Seasons, and understanding how these entities would interact within the game. The focus was on ensuring that our design was robust enough to handle all potential scenarios in the game.

Logical Design:
Next, we transitioned to the logical design phase, where we refined our conceptual model into a detailed blueprint for the database structure. This involved normalizing the data to eliminate redundancies, defining primary and foreign keys, and establishing relationships between tables. We focused on optimizing the database for efficient querying and reporting, essential for tracking the dynamic and evolving nature of the game.

Implementation:
Finally, we moved to the implementation phase, where we brought our design to life using SQL. We created tables, defined relationships, and populated the database with real data from past and current seasons of Cal Poly Survivor. We also developed queries to extract key insights, such as tracking individual performance metrics per episode and overall progress across seasons.

Importance:
This project was not only a practical application of the theoretical concepts we learned in class but also a crucial tool for managing the complexity of the game. The database allowed us to automate the tracking of player statistics, streamline the management of game records, and provide detailed analytics on gameplay. This data-driven approach enhanced the overall experience for participants and spectators alike.

5,000+

Data Points loaded in

Data Points loaded in

80+

Hours spent on project

Hours spent on project

SQL Learned

Outcome

Outcome

Reach out anytime!

Joshlavin03@icloud.com

Reach out anytime!

Joshlavin03@icloud.com

Reach out anytime!

Joshlavin03@icloud.com