You have decided to develop an online database to keep track of music releases and the artists involved (similar to IMDb). After a meeting with your team, you have developed the following list of information that needs to be kept track of in the database.

For each artist we would like to record their name, date of birth (or at least a year), hometown, and optionally a website and/or twitter account.

Bands are a collection of one or more artists, where each artist has one or more roles in the production/performance of their music. We want to keep track of which artists are in each band and what role(s) they participate in. We also want to be able to track historical information if they move from one band to another or if they disband and reunite.

For each song released we want to record the title, composer(s), album, artist/band, release date. Copyright is often a very complicated agreement between the band and composers, we need to be able to keep track of everyone who is due copyrights on each song. For the purpose of this database we will identify a single composer for each song produced.

An album is a collection of songs that may be from one artist/band or various. For each album we would like to know the album title, songs, band who released each song, producers, release date and studio.

NOTE: Be sure to consider any participation and key constraints that may not be explicitly mentioned. If you find a situation where there could be a choice of different constraints that could be applied you must include with your diagrams or relations an explanation of why you choose to implement it the way that you did.

Draw the ER diagram to represent the data model for this project. Include in the data model all entities, relationships, attributes and all possible constraints. In any case where a constraint can not be identified with the ER model please include a description of it in a write-up.