After taking the course on Database Management, you are told to develop a database for music like the Spotify Music App Database.

$1.$ Draw an Entity$-$Relationship diagram for the database.

$2.$ Write $2$ statements in DDL and $2$ in DML to define and manipulate the above database.

$3.$ Write $4$ statements in DQL to query the database created.

Total Marks: $12$

Evaluation Rubrics:

Question No$.$ Criteria$/$Description Marks

$1$ Identification of Entities and Attributes $2$ marks

Identification of Relationships $1$ mark

Cardinality Ratio $1$ mark

$22$ Data Definition Language statements $2$ marks

$2$ Data Manipulation Language statements $2$ marks

$34$ Data Query Language statements using SELECT $($each statement with different construct$)$