A Spotify like music application made with using the JDBC API with Oracle as a mini project for Database Management Systems Course.
It has a GUI for admin login which allows admin to add new albums, artists and upload new songs to the server. It also has a GUI for user login where the user can search the songs and play them. The user can also perform trivial operations like
- List all the songs of an artist or album.
- List most popular songs.
- Search for a song using song/artist/album name.
The database was created in oracle 11g and all tables are normalized upto 3NF.