Question
Design an ER diagram for keeping track of information of votes taken in the US House of Representatives during the current two-year congressional session, according
Design an ER diagram for keeping track of information of votes taken in the US House of Representatives during the current two-year congressional session, according to the following requirements
The database needs to keep track of the States name, States code, and the congresspersons sent by the state. Each congressperson is described by their name, district represented (unique number within a state), the political party they belong (whose domain is {Republican, Democrat, Independent}), and date elected. The database keeps track of each bill (i.e. proposed law), including the bill name, bill number (unique by each congressional session), date of vote, whether the bill passed or defeated, and the sponsor (the congressperson(s) who wrote the bill). The database keeps track of how each congressman voted on each bill (domain of vote is {Yes, No, Abstain, Absent)).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started