(Solved) : Design Er Schema Using Ie Notation Keep Track Information Votes Taken Us House Representat Q31475180 . . . .

Design an ER schema using IE notation to keeptrack of information about votes taken in the U.S. House ofRepresentatives 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 isdescribed by his or her Name, plus the District represented, theStart_date when the congressperson was first elected, and thepolitical party to which he or she belongs (whose domain in{‘Republican’, ‘Democrat’, ‘Independent’, or ‘Other’}. The databasekeeps track of each Bill (i.e., proposed law),