roblem $1$:

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', 'California'$)$ and include the Region of the state $($whose domain is $\{\text{'}$Northeast$\text{'},$ 'Midwest', 'Southeast', 'Southwest', 'west'$\}).$ Each CONGRESS$\_$PERSON in the House of Representatives is described by his or her Name, plus the Discrict represented, the Start$\_$date when the congressperson was first elected, the political Party to which he or she belongs $($whose domain is $\{\text{'}$Republican$\text{'},$ 'Democratic', 'Independent', 'Other'$\}).$ The database keeps track of each BILL $($i$.$e$.,$ proposed law$),$ including the Bill$\_$name, the Date$\_$of$\_$vote on the bill, whether the bill Passed$\_$or$\_$failed $($whose domain is $\{\text{'}$Yes$\text{'},\text{'}$No$\text{'}\}),$ and the sponsor$($the congressperson$($s$)$ who sponsored$--$that is$,$ proposed$--$the bill$).$ The database also keeps track of how each congressperson voted on each bill$($domain of Vote attribute is $\{\text{'}$Yes$\text{'},\text{'}$No$\text{'},$ 'Abstain', 'Absent'$\}).$

Additional information: $(1)$ There are $435$ congresspersons in the U$.$S$.$ House of Representatives; $(2)$ States have between $1$ and $52$ representatives; $(3)$ A bill has to be proposed by at least $1$ congressperson; and $(4)$ A congressperson can only represent one state.

Please use the $($min$,$ max$)$ notation to specify relationship cardinality. Please also state any assumptions you make.

Problem $2$:

Considered the following ER diagram for part of a BANK database. Each bank can have multiple branches, and each branches can have multiple accounts and loans.

$1.$ Identify weak entity and partial key.

$2.$ Redraw the ER diagram with notation $($min$,$ max$)$ to represent the entity relationships.