Design an ER schema using IE notation to keep 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 Name (e.g., Texas, New York, California) and 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 District represented, the Start_date when the congressperson was first elected, and the political party to which he or she belongs (whose domain in {Republican, Democrat, Independent, or Other}. 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 domain is {Yes, No}), and the Sponsor (the congressperson(s) who proposed that is, proposedthe bill). The database keeps track of how each congressperson voted on each bill (domain of vote attribute is {Yes, No, Abstain, Absent}).

Draw an ERD and state clearly state your design requirements and constraints.

Ref:

List of regions of the United States

https://en.wikipedia.org/wiki/List_of_regions_of_the_United_States

United States House of Representatives and Districts:

https://en.wikipedia.org/wiki/United_States_House_of_Representatives and

https://en.wikipedia.org/wiki/List_of_United_States_congressional_districts