2 Construct an ER diagram to model a database for the given information Suppose that you are designing a schema to record information about reality shows on TV. Your database needs to record the following information: a. For each reality show, its name, genre, basic_info and participants name. Also any reality show has at least two or more participants. b. For each producer, the company name, company country. A show is produced by exactly one producer. And one producer produces exactly one show, For each television, its name, start year, head office. A television may broadcasts multiple shows. Each show is broadcasted by exactly one television. For each user, his/her username, password, and age. A user may rate multiple shows, and a show may be rated by multiple users c. d