A database for a music store needs to be developed.

For each Artist (band), store the name, ID and country. Artist IDs are unique. An Artist has one or more albums.

For each Album, store its title, ID, year, price. An album has a genre, a format, and a single artist.

For each Genre, store its name and ID. For each Format (e.g., digital, CD, Vinyl), store its name and ID.

Each Customer has a name, preferred genre, and ID, which is unique.

When a Customer places an Order, we need to store the order ID and the date

Assume a Customer can purchase only one Album per order.

Your task: Draw a entity relationship diagram that covers the requirements above. Do not forget to include cardinality and participation constraints.