sudharsan s

sudharsan s

  • NA
  • 204
  • 87.1k

Data modeling Diagram ?

May 28 2013 8:43 AM

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,