Need Answer for 2 and 3 Questions
A database that is used for keeping track of information about the votes taken in the US House of Representatives during the current two-year congressional session. The database needs to keep track of each US State's name (e.g., 'Textas', 'Newyork', Califonia') and include the region of the state (whose domain is {'Northeast', 'Midwest', Southeast', 'Southwest', 'West'}). Each 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', and 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 {'Yes', 'No'}, and the Sponsor(the congressperson(s) who sponsored- that is, proposed – the bill). The database keeps tracks of how each congressman voted on each bill (domain of Vote attribute is {'Yes', 'No', 'Abstrain', 'Absent'}.
1. Draw an ER diagram
2. Convert the ER diagram to DM
3 . Give an event tracking factless fact table
Design an ER diagram for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session…. Draw an ER schema diagram for the above application. State clearly any assumption you make.
Entities:
STATE
Name, RegionOfState
CONGRESSPERSON
Name (FName, MInit, LName), District, StartDate, PoliticalParty
BILL
BillName, PassedOrFailed,