Database sytems

1. (100 POINTS) Please read the following requirements specification carefully and then answer the two questions: "We are interested in a system to keep track of the music bands and their related information. Every music band has a permanent singer with a voice type in (Bass/Alto/Tenor/Soprano) who may or may not be accompanied by the other artists. Artists have a unique name and either sing or play an instrument or both. Some of the players are Guitarists and we care about the type of guitar they play as well as the make / model of their favorite guitar. A Band is reputed for a single style (Hard Rock, Blues, Jazz...). We assume that no two players in a band play the same instrument. But an artist can perform in several bands. Every concert is held in a venue and venues are known by their unique name like Albert Hall in London or Acropolis in Athens. However, each music band holds at most one concert in a venue. Each band has potentially couple of albums published in a specific year and in each album there exist couple of songs identified by the track number and each has a song name. (Hint: Pink Floyd The wall" has track #3 and Katy Perry's "Teenage Dream" has also track# 3, Think of a good candidate for PK) Each band has an official fan club and fans may or may not be a member of that club and the system also keeps track of the concerts each fan attends