draw an erd for a database for keeping track of information about votes taken in the u.s. house of representatives. the database needs to keep track of each state’s name and the region of the state (northeast, northwest, etc.), and each state has a 2-character state code in addition to state name. each congressperson in the house of representatives is described by their social security number, name, district represented and start date when they were elected, and the political party they belong to. the database keeps track of each bill (proposed law), and includes the bill’s id, name, the date of vote, whether the bill passed or failed. a bill may be jointly proposed by several congressperson, and a congressperson may propose more than one bill. the database keeps track of how each congressperson voted on each bill, either yes or no.