How to name the associative entities

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

Reviews

Write a Review

Required(*) Message

Computer Engineering Questions & Answers

Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

Security policy document project

Analyze security requirements and develop a security policy

Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd