SYMPHONYC: The database of a music streaming service similar to Spotify.
A project regarding the Database course. This project consists of:
- Initial Information Gathering for building a database
- Enhanced entity-relationship model
- Relational Model
- SQL codes for implementing and setting up this database
- Admin and Model codes for setting up and connecting the database to Django
- Python codes to analyze, gather helpful information out of the database, and plot them via matplotlib
- some extra SQL codes to learn and master the SQL itself
Github repo
Initial Information Gathering for building a database:
DB Entities & their Attributes
Enhanced entity-relationship model:
Relational Model:
