Questionemerging electric wishes to produce a database with, 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.:- M9718870

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

On the spot courier services grew and changed over the

On the Spot courier services grew and changed over the years. At first, Bill received requests for package pickups on his mobile phone, recorded that information in a log, and would then drive around to retrieve all the ...

Take a position on whether user interfaces for work will

Take a position on whether user interfaces for work will remain isolated or become more collaborative. Present evidence, based on the different categories of social media, to support your argument. Include at least two r ...

Question a tank for propane gas is a cylinder with

Question : A tank for propane gas is a cylinder with hemispheres at each end. Write a process that asks the user to enter the length of the cylinder and the radius of the cylinder (same as the radius of the hemisphere (s ...

Assignment - confidential organizational information and

Assignment - Confidential Organizational Information and Employee Responsibility As an employee, you are often required to sign confidentiality agreements when beginning work at a new company. You may also be required to ...

Question write 1 page that respond to the following

Question: Write 1 Page that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to ...

Question in the link below it has all the information that

Question: In the link below it has all the information that needs to be in the crowsfoot erd. Don't take on this assignment if you cant put all the info in the ERD. The instructor will grade the work that you do and send ...

Suppose we evaluate the performance of a player based on

Suppose we evaluate the performance of a player based on the player's HR and RBI score. Assume each HR counts as 3 points while each RBI counts as 2 points. Find the playerIDs who have the highest score. -Select a random ...

A confidence interval for a population mean is to be

A confidence interval for a population mean is to be estimated. The population standard deviation is guessed to be anywhere from 14 to 24. The half-width B desired could be anywhere from 2 to 7. Tabulate the minimum samp ...

A study was conducted of long beach school district schools

A study was conducted of Long Beach School District schools regarding how many require school uniforms. In 2006, of the 296 schools questioned, 184 said they required s school uniforms. (Gentile & Imberman, 2009) Find th ...

Question suppose a process ie parent forks a child process

Question : Suppose a process (i.e., parent) forks a child process using resource sharing such that the parent and child share all resources. Does this include the Process Control Block and memory space or does the child ...

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