DBMS course project on Music Management Database using various PL/SQL queries.
Music management database provides the user with relevant information regarding the preferred music genre, which is popular in their respective countries. The music database can be used by various music streaming platforms like, spotify, apple music etc. It consists of various tables with the relevant entities. For the ease of this project, we have used FOUR major tables. The user can easily access any required entry from the database using some simple PL/SQL queries. DDL/DML commands, basic/advanced select statements, PL/SQL statements, functions, procedures, triggers, cursors and exception handling.
Music Management Database consists of the following tables:
-> Genre (associated with different countries)
-> Artist (Popular artists of that genre)
-> Files (The description of music files)
-> Songs (Most popular songs by that artist)
Worked on various basic DDL, DML commands, functions, procedures, triggers, cursors and exception handling.
->There are total of four entities with their respective attributes.
->Each entity (genre, artist, files, song) contains a primary key.
->The entities artist, files and song are binded with genre entity with foreign keys.
->There is one-to-many relationship available between genre, artist, song and files.