Use Oracle SQL Developer Data Modeler to make an ERD logical model and show the relational model generated from this logical model

1. ERD must support the business requirements as detailed here. The only submissions necessary for this assignment is the completed ERD logical model picture and the relational model picture submitted as PDF's. The word document is OPTIONAL.
2. Correctly draw all entities and attributes of entities as well as relationships between entities in Data Modeler. Do not worry about supertypes and subtypes here.
3. Break up entities like name and address into individual components (such as first name and last name, street address, city, state, zip)

Question

The database needs to keep track of each U.S. STATE's Name (e.g., Texas, New York, California), abbreviation, state capital, and the region of the country (eg. Northeast, Northwest, Southeast, Southwest).

 

You need to provide structures to keep track of the various districts within each state, and the population of each district. For example, California has 53 districts and Rhode Island has 2 districts. 

 

Each CONGRESSPERSON in the House of Representatives is described by their Name, and includes the District represent, the state, date of first term start, their email, and the political Party to which they belong. 

 

The database keeps track of each BILL (i.e., proposed law), and includes the Bill Name, the Date of Vote on the bill, whether the bill Passed Or Failed, and the Sponsor (the congressperson(s) who sponsored--i.e., proposed--the bill).  You should assume that each bill may have more than one sponsor. 

 

The database keeps track how each congressperson voted on each bill, (domain of vote attribute is {Yes, No, Abstain, Absent}).

 

Each bill may have one or more hearings. You should be able to keep track of when each hearing was for each bill including the date and time, and the volume and page of the congressional record. 

 

Example Bills (this is sample data, attribute names would be the heading names.) You do not need to fill in any of the sample data, this is provided to help you understand the nature of the business environment that you are modeling.

 

Bill number			Bill name		Date of Bill	Pass or Fail
100				Dog Cruelty Bill	9/1/2020	P
200				No spitting on sidewalk	10/1/2001	F
300				No lunch before dinner	5/30/2022	P