1) (35 points) In Assignment #1 an ER scheme diagram for the application: keeping track of information about votes taken in the U.S. House of representatives during the current two- year congressional session is shown below a) (15 points) Please refer to the small world of question 4 in assignment #1 convert the ER model into a relational schema. Specify all primary keys and foreign keys on the relational schema. For each relation please indicate the step and method described in Class Note #6, which you have used. b) (8 points Check the relations in your relational schema to indicate whether each of them is in 3NF. Why? c) (12 points) Create the corresponding relational database that includes all necessary tables by using MySQL. Show your interactive execution by a script file Figure 1: The ER scheme diagram for votes taken in the U.S. House of representatives