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), Telephone
• Location, with attributes Location_ID, Address (Street, City, State, Zip code), Type (values of Business or Residential)
• Rate, with attributes RateClass, 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, depending on the time of day. Draw an ERD for this situation, and place minimum and maximum cardinalities on the diagram. State any assumptions that you have made.