Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Larry Ellison Database Genius Of Oracle

Authors: Craig Peters

1st Edition

0766019748, 978-0766019744

More Books

Students also viewed these Databases questions

Question

7. Determine what feedback is provided to employees.

Answered: 1 week ago