How to name the associative entities

Assignment Help Computer Engineering

Reference no: EM133202

Question

Emerging Electric wishes to produce a database with the following entities and attributes:

1. Customer, with attributes Customer_ID, Name, Address (Street, City, State, Zip code), Telephone

2. Location, with attributes Location_ID, Address (Street, City, State, Zip code), Type (values of Business or Residential)

3. Rate; with attributes RateClass, Rateperkwh
After interviews with the owners, you have come up with the following business rules-

4. Customers can have one or more locations.

5. Each location is able to have one or more rates, depending on the time of day. Illustrate an ERD for this situation, and place least and utmost cardinalities on the diagram. State any assumption that you have made.

Reference no: EM133202

Questions Cloud

Solve the problem using python programming : Solve the problem using PYTHON Programming

Consider the business impact of any situation : Consider the business impact of any situation

Why we have a divide databases and data warehouse : Why we have a divide databases and data warehouse

Write down problem on strings in java : Write down problem on strings in java

How to name the associative entities : How to name the associative entities

List the top advantages of migrating to ipv6 : List the top advantages of migrating to IPv6

Write down a recurrence relation : Write down a recurrence relation

Problem on boolean calculator : Problem on Boolean Calculator

What aspect of data is problematic : What aspect of data is problematic

User Account

All Pages