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,