Question

The IT Director at the Regional Economic Studies Institute (RESI), an economic and policy analysis/research group at Towson University, learned that you are taking a database management system class this fall, and she decided to hire you as a DBA. They would like to design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., ‘Texas’, ‘New York’, ‘California’) 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’, ‘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 also keeps track of how each congressperson voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}). Your first task is on the job is to draw an ER diagram for this application. State clearly any assumptions you make.

Answer 1

An ER diagram consist of three things:-

1)Entities:-Entities such as US_States_Area,Congress_Person,Bill

2)Attributes:-Attributes includes US_staste_Name ,Region_of_state ,name,start_date ,party_domain ,bill_name,date_of_vote,pass or fail,sponsor,etc

3)Relationship:-It is shown between US_States_Area,Congress_Person,Bill where  US_State_Area is related to Congress_Person by relationship REPRESENT, Bill is related to CONGRESS_PERSON by vote and sponsor

The assumptions that we can made here are :-

1) Each CONGRESS_PERSON can represent one district

2)One district is represented by one person

3) Every BILL should be unique.

Note:-The cardanility between different entities is shown above

********************************************************************************************************************

In case of any doubt do ask in the commment section.Hope you like it