Emerging Electric wishes to create a database with the following entities and attributes:• 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.Draw an ERD for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made.
Emerging Electric wishes to create a
• 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.
Draw an ERD for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
