Question: Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation: Emerging Electric wishes to create a database with the

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation:

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

Customer with attributes customerID, name, address

(street, city, state, zipCode), telephone Location with attributes locationID, address (street, city, state, zipCode), type (business or residential)

Rate with attributes rateClass, 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 upon 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 Database Management Systems Questions!