The Case of ABC Electric:

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

  • Customer, with attributes Customer_ID, Customer_Name, Customer_Address (Street, City, State, Zip code), Customer_Type (Business or Residential)
  • Location, with attributes Location_ID, Location_Name, Location_County
  • Rate, with attributes Rate_Class, Rate_Per_ kwh

After interviews with the company employees and its customers, you have come up with the following business rules:

  • Locations are geographical areas such as cities, towns, etc.
  • Customers can have one or more locations.
  • Each location can have one or more rates, depending on the time of day.

Question 1 for the Case:

Please use either Access notation or ER modeling notation to develop a logical database model for the company. You also need to (1) create associative entities (with attributes) to simplify many-to-many relationships whenever necessary, and (2) use verbs to describe the relationships. Similar database model can be found in slide 7.12, which uses ER notation. The Draw function in Microsoft Word is preferred to illustrate the model.

Question 2 for the Case:

Write SQL statements to develop database tables for each of these entities in the model. Similar SQL statements can be found in slide 7.13.

Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.