Question: Develop an ER model for the following situation: An electricity company wishes to create a database with the following entities and attributes: Customer, with attributes

Develop an ER model for the following situation:

An electricity company wishes to create a database with the following entities and attributes:

  • Customer, with attributes CustomerID, Name, Address (Room, Floor, Building, Street, StreetNum, District, City), Type (values of Business or Residential)
  • Location, with attributes LocationID, Address (Room, Floor, Building, Street, Street_Num, District, City)
  • Rate, with attributes RateClass, RatePerKWH

You are also provided 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!