How to name the associative, Ask an Expert

Engineering

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.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M9133618

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

How is international trade regulated what is involved in

How is international trade regulated? What is involved in "trade agreements"?

Compare remote authentication dial-in user service radius

Compare Remote Authentication Dial-In User Service (RADIUS) and Terminal Access Controller Access-Control System Plus (TACACS+).

If we believe the percent to be 75 how many police officers

If we believe the percent to be 75%, how many police officers must we survey to estimate the proportion of officers who graduated from a police academy if we want to ensure we can be 99% we are within 2% of the true prop ...

Electric car technology has been improving and the us shale

Electric car technology has been improving and the U.S. shale gas oil supply has been increasing. What will be the impact on the crude oil market price? What will be the impact on the gas-burning auto market price? Expla ...

Part 1whats the importance of a documentation plan please

Part 1: What's the importance of a Documentation Plan? Please provide an example of a Documentation Plan that you would use. Part 2: How do you calculate how long a project will take? These questions are for my Introduct ...

A different ethanol processing facility costs 800000 to

A different ethanol processing facility costs $800,000 to construct but will instead last forever. Every year (starting the year after construction), it produces 10,000 barrels of ethanol and can charge a price of $4 per ...

If the annualized five-year rate of return is 15 and if the

If the annualized five-year rate of return is 15%, and if the first year's rate of return is 20%, and if the returns in all other years are equal, what are they? Provide the answer in % with four decimal places without r ...

Suppose that you have a singly-linked list l containing the

Suppose that you have a singly-linked list L containing the sequence of numbers (1,2,3,4,5,6,7,8,9). Suppose further that you have an initially empty stack S. i) Give a pseudo-code description of a method that uses only ...

Question the below table shows the instruction count ic for

Question : The below table shows the instruction count (IC) for programs running on three processors P1, P2, and P3 with the clock rates 1.0 GHz, 2.5 GHZ, and 2.0 GHz respectively. Each program consists of only Load/stor ...

Suppose there is exactly one packet switch between a

Suppose there is exactly one packet switch between a sending host and a receiving host. The transmission rates between the sending host and the switch and between the switch and receiving host are R1 and R2 respectively. ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert