Emerging Electric wishes to create a database with 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

Rate, with attributes Rate Class and RatePerKWH

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

A rate may be for one, none, or many locations

Draw an ERD for this situation and place minimum and maximum cardinalities on the

diagram and name all the relations. State any assumptions that you have made.