Draw ER diagrams for following Descriptions, all parts are connected to each other. Output of part A will be used in part B and will be expanded and Output diagram of part B will be used in part C$.$

Emerging Electric wishes to create a database with the following entities and attributes:

A$.$ Customer with customer id$,$ Name, Telephone and Address where address contains Street, City, State and Zip code

B$.$ Location with attributes Location ID$,$ Address $($where address contains Street, city, state and zip code$)$ and Type $($where type can be Value of Business and Residential$)$

C$.$ Rate with attributes Rate Class and Rateper KWPH

After interviewing with the owners, you have come up with following business rules:

$1.$ Customer can have one or more locations and vice versa

$2.$ Each location can have one or more rates depending upon time of day.

Draw ER Diagram and place Cardinalities and multiplicities required and more over make sure no M:N relationships should exist, they should be broken down to $1$:M:$1.$

Make sure all different types of attributes should be marked with different symbols to represent their type like Required, Optional, Derived, Stored, Single Valued, Multi$-$Values etc.