Case Study: You are required to: 1. Draw an Entity Relationship Diagram (ERD) that represents this case study; 2. Resolve any M:N relationships that occur in the ERD. Origin Energy Australia wishes to create a database with the following entities and attributes: Customer, with attributes Customer ID, Name, Address( Street, City, State, ZipCode), and Telephone Location, with attributes Location ID, Address( Street, City, State,ZipCode) and Type( values of Business or Residential) 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, depending on the time of day. Notes: The third party payment site is out of scope for this question and can be ignored. The ERD must show names for both entities and relationships. The ERD must indicate the cardinality (ie. one-to-one, one-to-many or many-to-many) of all relationships. The ERD does not need to show attributes. List any assumptions that you make.