Draw an E.R.D with connectivity and cardinalities for the following narrative: Design 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 U.S. State's Name (e.g. Minnesota, Texas, etc.), and includes the Region the state is in (e.g. Midwest of USA, Southeast of USA, etc.). Each congressperson in the House of Representatives is described by their Name, the District represented, the StartDate when they were first elected, the political party they belong to (e.g. Republican, Democrat, Independent, other). The database keeps track of each Bill (i.e. proposed law), and includes the BillName, the DateofVote on the bill, whether the bill PassedOrFailed (e.g. Yes, or No), and the Sponsor and co-sponsors (the congressperson(s) who proposed the bill). The database keeps track of how each congressperson voted on each bill (e.g. Yes, No, Abstain, Absent). State clearly any assumptions you make. If a relationship is many to many (M:N), introduce a bridge entity to break it into two 1:M relationships. The attributes given are meant to help you understand the scenario. Don't include them on your ERD