Question :
Generate an ERD diagram for the following scenario using Lucidchart. I need to know what the diagram should look like.
(I am not sure there should be any kind of relationship between entities.)
Scenario: Southlands Electric
Southlands Electric wishes to create a database with the following information:
Customer with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone
Location with attributes Location ID, Address (Street, City, State, Zip Code), 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