Question #$1$:

We would like to design a database to store information about votes taken in the United

States congress $($House of Representatives$)$ during the current house session. The

database requirements are as follows: Information is kept about each STATE $($e$.$g$.$ Texas,

New York. California, etc.$),$ which is the state name $($unique for each state$),$ capital city,

current population, and region $($e$.$g$.$ Northeast, Midwest, Southeast, Southwest, West,

etc.$).$ Information is also kept about each REPRESENTATIVE, which includes the

representative's id$\_$number $($unique for each representative$),$ name, the state he or she

represents, the number of the district $($from which the representative was elected$),$ the

start date $($when the representative started representing the district$),$ and the political party

of the representative $($e$.$g$.$ democrat, republican, independent, etc.$).$ Information for each

BILL $($i$.$e$.$ proposed law$)$ includes the bill number $($unique for each bill$),$ bill name, date

of the vote on the bill, whether the bill passed or failed, and the sponsoring

representatives who proposed the bill. Information is also kept on each individual vote of

a representative on a bill, and the type of vote cast $($for$,$ against, abstain$,$ absent$).$

Design an ER schema diagram to represent the above database. State clearly any

assumptions that you make.