In this assignment, you should model a Discography system with the following requirements:

Each artist has a unique name, which consists of a first name and a last name. Furthermore,each artist can have several pseudonyms. For example, the artist Stefani Joanne Angelina Germanotta performs under the pseudonym Lady Gaga. An artist can record several albums.Each album has a unique name and a unique id$.$ Every album is performed by one artist.There are multiple songs on each album. Each song must belong to exactly one album. For each song, the song duration, name, and position on the album are stored. Further to each album is stored, how many songs are on the album.

Create an Entity$-$Relationship$-$Diagram $($ERD$)$ in MC notation that captures the described information and is designed in a slim and thought$-$out way. The Entity$-$Relationship$-$Diagram should consist of entity types, attributes, relationship types, and cardinalities in MC notation. Please indicate possible identifying attributes, multivalued attributes, derived attributes, and compound attributes if any. Use given keywords as names for entity types, attributes, and relationship types and find appropriate attributes and names, when needed. Explain the cardinalities of the relationships.