Question: Can yiuvhelp me with designing the ER schema please? For database Design an ER schema for keeping track of information about votes taken in the
Design an ER schema for 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 Califomia') and include the Region of the state (whose domain is f'Northeast', 'Midwest', 'Southeast', 'Southwest', 'West']). Bach 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 is ('Republican', "Democrat', 'Independent', 'Other')). The database keeps, track of each Bil name, the Date of vote on the bill, whether the bill Passed or failled (whose domain is ('Yea', 'No')), and the Sponsor (the congressperson(s) who sponsored-that is, proposed-the bill). The database keeps track of how each congrossperson voted on each bill (domain of Vote attribute is ('Yes', 'No', 'Abstain', 'Absent')). Draw an ER BILL (ie, proposed law), including the- schema diagram for this application. State clearly any assumptions you make
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
