Consider the scenario from Homework 2 where you designed an ER diagram for the Emerging Electric.  

Task 1: Convert the ER diagram into relational schemas and capture as many of the constraints as possible. 

Task 2: Based on ERD and relational schemas from Task 1, implement the design by constructing SQL statements  

================================================================= 

Note: Please use Sample Solution to Homework 2 for this assignment. 

Homework-2 Emerging Electric wishes to create a database with the following entities and attributes Customer with attributes Customer ID Name Address Street City State Zip Code), and Telephone Location with attributes Location ID Address Street City State Zip Code and Type values of Business or Residential) Rate with attributes Rate Class and Rate Per KWH After interviews with the owners, you have come up with the following business rules Customers can have one or more locations. Each location can have one or more rates depending on the time of day Homework 2 Solution Location Rate Customer Loc id Rate class Cust id Loc address Rate per kwh Cust address Has Street Street Has City State State Zipcode Zipcode Loc type Cust telephone Time-of-day Assumptions 1) Cust id is uique in Customer Loc id is unique in Location. 2) A location is owned by one customer a rate can be associated with multiple locations 3) Rate-class is unique each location is associated with multiple rates determined by rate-class depending on the time of day