Requirements. A television channel has decided to create a simple database to register payment information about its most successful show "TheVoiceLondon'. In this show, there are contenders that compete to represent the UK in Eurovision. These contenders are coached by famous artists (namely the coaches). Contenders can be formed by a group of participants or a single participant. Both coaches and participants are paid based on the number of shows they attend. For each coach and participant, the database stores their id, name, surname, date of birth, phone, gender and daily salary For each contender, the database stores its id, type (group or individual), stage name, its coach and the participants forming that contender. Each contender should have at least one participant. For each show, the database stores its date, start time, end time and a location if the show does not take place in the television studio Finally, the database also registers which coaches and contenders attended each show If a coach decides to leave the program, then their personal and attendance information must be deleted from the database and any contenders they coach need to be assigned a replacement coach. The following relational schema contains the database model for this TV show. In the relational schema below, primary and foreign keys are not given to you. Coach name surname DoB idCoach phe dailySalary gender Contender stageName type idContender coach Participant surname DoB idParticipant phone dailySalary gender contender name TVShow location date idShow startTime endTime CoachlnShow coach show ContenderinShow contender show 1.1 ER Diagram. Draw the ER Diagram that corresponds to the above requirements. Include all entities, attributes, and relationships. If necessary, please explain/justify your design choices. 1.2 Cardinalities and Assumptions. On the ER Diagram include all cardinalities of the relationships using the ERD (min, max) notation from lecture. State assumptions made and ensure that those assumptions do not contradict with the coursework requirements. Please listyour assumptions as bullet points. 1.3 Constraints. For each relation, identify their primary and foreign keys. You may write (PK) and (FK) to indicate the attribute(s) that serve as primary and foreign keys, respectively. For example, 'ProjectNumber (PK), EmployeeNumber (FK)