Music Database
A relational music database designed to explore how albums, artists, genres, regions, and historical context can be structured, queried, and meaningfully explored.
Project Overview
This project began as an effort to model music beyond simple playlists or genre labels. Instead, it focuses on capturing relationships between sound, era, geography, and cultural context using a structured relational database.
The goal is to support flexible querying and exploration—such as browsing by sound, movement, or time period—rather than relying on rigid hierarchies.
System & Technology
- Python
- SQL (Relational Database Design)
- Flask
- HTML / CSS
Data Model & Design Decisions
The database is structured around core entities such as albums, artists, genres, labels, and regions. Albums can be associated with multiple stylistic categories to better reflect genre blending and musical evolution.
This design prioritizes clarity, extensibility, and meaningful relationships over rigid classification.
Interactive Database Interface
Select a tab to explore the database.