Designing an Entity Relationship Diagram for Emerging Electric

The assignment content describes the creation of an Entity-Relationship Diagram (ERD) for Emerging Electric. The ERD consists of three entities: CUSTOMER, LOCATION, and RATE. The CUSTOMER entity has attributes such as Name, Customer ID, Customer address, and customer phone, while the LOCATION entity has attributes like Location ID, Location type, and Location address. The RATE entity has attributes Rate Per KWH and Rate Class. The ERD also shows relationships between entities, including 'Located In' (Mandatory Many) between CUSTOMER and LOCATION, and 'Is Charged' (Optional many and Mandatory Many) between LOCATION and RATE.

Step 1:
Entity Relationship Diagram
 An ERD is a graphical demonstration of entity-relationship model.
 It’s a logical representation of business data for a business area is the E-R model or entity-
relationship.
 When it comes to the business environment, the ER model is expressed in terms of relationships
and entities.
 The properties of entities and relationships are expressed in the ER model.
Step 2:
E-R diagram for Emerging Electric
 The entity CUSTOMER has the attributes Name, Customer ID, Customer address and customer
phone.
 Customer Address is a composite attribute. It’s a combination of a few simple attributes such as
State, Street, City and Zip code
 The entity LOCATION has the attributes Location Address, Location ID, and Location type
 Location Address is a composite attribute. It consists of simple attributes such as City, Street, Zip
code and State.
 The entity RATE has the attributes Rate Per KWH and Rate Class.
Step 3:
Representation of E-R Diagram
- - - - - - - - - - - - - - -
Is Charged - - - - - -
CUSTOMER
Customer ID:
Customer Name
Customer
Address
(Street, City,
State, Zipcode)
Customer Phone
Located In
LOCATION
Location ID:
Location Type
Location
Address
(Street, City,
State, ZipCode
Time of Day
RATE
Rate Class
Rate Per
KWH

Step 4:
Explanation of E-R diagram above
A Customer and Location are the entities that are related with a relationship called Located In
The Cardinalities that is present in this relationship are Mandatory Many
It states that a Customer may be able to have multiple own locations
One or more customers may have that one number of locations
A Location and Rate entities are the ones that are related with a relationship called Is Charged
The Cardinalities that is present in this relationship are Optional many and Mandatory Many
A Rate can be different from one, none or many Locations
A Location can have multiple customers