spotify database project
creating a database to simulate a music streaming platform
summary
this project was my introduction to backend coding, assigned in an intro to databases course at columbia. each pair was tasked with developing a database with real-world functional purpose. my partner and I tacked on a basic frontend.
role
I worked with a partner to map out and implement our database. we first created a detailed entity-relationship diagram, allowing for model visualization before coding. we used postgresql, python, html, and javascript for our implementation.
organization
columbia university
summary
this project was my introduction to backend coding, assigned in an intro to databases course at columbia. each pair was tasked with developing a database with real-world functional purpose. my partner and I tacked on a basic frontend.
role
team developer
timeline
four weeks
role
I worked with a partner to map out and implement our database. we first created a detailed entity-relationship diagram, allowing for model visualization before coding. we used postgresql, python, html, and javascript for our implementation.
organization
columbia university
completed
may 2023
entity-relationship diagram
our e-r diagram was predicated on ways which a user would interact with a streaming service. beyond connecting albums, tracks, and artists within the music library, we also had to consider ways in which the user consumes liked tracks and receives recommendations.
technology
once we had aligned on the appropriate entity mapping, we manually created these relational tables using postgresql. we populated the tables with sample data to ensure that the relationships held.
as an enrichment activity, we added a very basic frontend on top of the database so that a sample user could easily interact with it. this feature allowed users to observe how their shifting likes and listening habits dictated the tracks recommended to them.
postgresql
python
.png)
html
javascript
postgresql
python
html
javascript
