You are to consider the design of a web app to help a night club track and promote the events that are held at the venue. These events can be either music (a solo artist or a band), a poetry reading by a solo artist or a comedy performance by a solo comedian.

The web app should be responsive, accessible, and easy to use, to be useable by a wide variety of users. The web app should use a MySQL database to store data (described below) and be user friendly throughout. The web app should have an admin interface to allow club staff to add and remove events. The system should keep a separate record of all artists including the name of performer (this will be the band name if the artist is a band), a brief biography, social media usernames for Facebook, Twitter and Instagram and the artists chosen PR image to be used in promotional material. Events should record the date and start/end time of the event, the event category (Music, Poetry or Comedy) the entrance fee applicable (which could be free), the maximum attendance capacity supported and details of the artist(s) performing. Admin pages must be protected by a login mechanism to ensure that only designated club staff can access these pages.The web app should also provide a view for the general public showing all the upcoming events in the next 6 months. This should allow the user to sort the events by date, category and artist name. In addition, it should be possible to see all past events held at the venue on a separate page.

iii) Entity-Relationship Diagram: You should create an ER diagram to meet the data needs of the club event promotion web app. Your ER diagram should clearly identify primary keys, foreign keys, attribute types and associativity between tables and should use relevant and appropriate database design principles.

ANSWER COMPLETE THIRD PART BY READING ABOVE GIVEN SCENARIO.