arent sure with the correct relational schema and ERD. hope i can get a right answer from u and would be much appreciated!

- Read the following narrative: Hawthorn Comedy Inc. is planning to hold a festival made up of vorious comedy shows. Every show will hove on ID, a title and a description. Each show is delivered by a comedian. Comedians hove a name, an address, contact number, and email. One comedion may deliver more than one show ot the festivol. Members of the public will come and visit the festival as ottendees. As each attendee enters the festival, their name, address and phone number will be recorded. Each attendee will be given a unique borcode id. During the visit, attendees will rote the show with a score of 1 to 10 . This will be recorded by stoff ot Hawthorn Comedy In Attendees will be able to vote for more than one show. - Create an ERD diagram based on the above narrative. Make sure that every entity name ends with 4 digits of your student ID. - The ERD may be neatly hand-drawn or can be drawn in a package like draw.io. - The symbols and style of the ERD must match the ERDs seen in lectures of this unit. If there are weak entities, make sure you use proper notation to indicate those. - Scan or take a screenshot of the ERD and place it in the document named T04P.DOCX - Convert the ERD to a Relational schema (DO NOT use surrogate keys) - Make up 2 pieces of Test data for each entity. - Copy and paste the relational schema and place it in the document T04P.DOCX - Copy and paste the Test data into the document TO4P.DOCX