(ER) Entity - Relationship

4) (25 points) Draw an ER scheme diagram for the following application: keeping track of information about votes taken in the U.S. House of representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE's Name (e.g., Texas, New York, California') and include the Region of the state (whose domain is {'Northeast',' Midwest', Southeast', Southwest, West'!) Each CONGRESS-PERSON in the House of Representatives is described by his or her Name, plus the Region represented, the Start-date when the congressperson was first elected, and the political Party to which he or she belongs (whose domain is {'Republican, Democrat',' Independent', Others'). The database keeps track of each BILL (i.e., proposed law), including the Bill-name, the Date of_vote on the bill, whether the bill Passed or failed (whose is "Yes', "No"]), and the Sponsor (the congressperson(s) who sponsored - that is, proposed - the bill). The database keeps track of how each congressperson voted on each bill (domain of Vote attribute is {'Yes", "No", Abstain", Absent'). State clearly any assumptions you make Additional information: - There are 435 congresspersons in the U.S. House of Representatives States have between one (AK, DE, MT, ND, SD, VT, and WY) and 52 (CA) representatives. M represents number of bills during the 2-year session