Design er schema to keep track of information of votes

Assignment Help Database Management System

Reference no: EM1358946

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 the following U.S. state's Name (Texas, New York, California and Iowa) and includes the Region of the state (whose domain is {Northeast, Midwest, Southeast, Southwest, West}). Each congressperson in the House of Representatives is described by their Name, and includes the District represented, the StartDate when they were first elected, and the political Party they belong to (whose domain is {Republican, Democrat, Independent, Other}). The database keeps track of each bill (i.e., proposed law), and includes the BillName, the DateOfVote on the bill, whether the bill PassedOrFailed (whose domain is {YES,NO}), and the Sponsor (the congressperson(s) who sponsored-i.e., proposed-the bill). The database keeps track how each congressperson voted on each bill (domain of vote attribute is {Yes, No, Abstain, Absent}). Draw an er schema diagram for the above application. State clearly any assumptions you make."

Reference no: EM1358946

Questions Cloud

Efficient frontier : Create a reasonable, but hypothetical, graph that shows risk, as measured by portfolio standard deviation, on the X axis and expected rate of return on the Y axis.

Describe employee training and development : Describe Employee Training and Development and Create an argument for investing in training and development to improve employee performance

Discuss emotions, escalation and fairness : Describe the roles of emotion and fairness in decision making and apply critical thinking skills to analyze business situations.

Compute effects of an appreciation and a depreciation : Compute effects of an appreciation and a depreciation in the exchange rate on the price of its output in that country and the likely effects on the demand for its output.

Design er schema to keep track of information of votes : 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.

Find the force exerted by the rope on the bucket : find the force exerted by the rope on the bucket. A metallic object is given the negative charge by the process of induction. What happens to object's mass.

Sub-specializations in clinical psychology : What are the four most common sub-specializations in clinical psychology?

Environmental management program : What one company has fallen short on one or all of these elements and Environmental Management Program

Find the amount of depreciation expense : A factory equipment was purchased for $60,000 on January 1, 2006. It was estimated that it would have a $12,000 salvage value at the end of its five year useful life.

User Account

All Pages