An electricity supply authority records on an electricity

Assignment Help Database Management System
Reference no: EM13945485

An electricity supply authority records on an electricity usage file the amount of electricity that each customer uses. This file consists of:

- a header record (first record), which provides the total kilowatt hours used during the month by all customers

- a number of detail records, each containing the customer number, customer name and electricity usage (in kilowatt hours) for the month.

Design a solution algorithm that will read the electricity usage file and produce an electricity usage report showing the customer number, customer name, electricity usage and the amount owing. The amount owing is calculated at 11 cents for each kilowatt hour used, up to 200 hours, and 8 cents for each kilowatt hour used over 200 hours. The total electricity usage in kilowatt hours is also to be accumulated.

At the end of the program, compare the total electricity usage accumulated in the program with the value provided in the header record, and print an appropriate message if the totals are not equal.

Reference no: EM13945485

Questions Cloud

Find and display the total owed for all taxpayers : Exit the program (If the user choices 4, the program will exit. If the user chooses 1, 2 or 3, the program will do what the menu item says it will do, and then the menu will appear again.
Use simultaneous equations to determine theoptimal : Use simultaneous equations to determine theoptimal values of the decision variables.
Balance in the pbo to change : What are some events that may cause the balance in the PBO to change
Why statistical analysis is used in criminal justice : Evaluate why statistical analysis is used in Criminal Justice/Security Management research, Evaluating sources (references) for Criminal Justice/Security Management research and Evaluate ethical research concerns as it applies to Criminal Justice/Sec..
An electricity supply authority records on an electricity : At the end of the program, compare the total electricity usage accumulated in the program with the value provided in the header record, and print an appropriate message if the totals are not equal.
Cost of goods sold and total dollar amount : Calculate the total dollar amount of cost of goods sold and total dollar amount of ending inventory for October assuming FIFO is used
The leadership opportunities in these organizations : Choose two professional organizations :- American Nurse Association and International Council of Nurses Create a table comparing the two organizations.
Develop a media presentation : Students will develop a power point media presentation. Presentation will require researching a module specific topic. For this activity you will research the four categories of reciprocating engines. In your presentation address the following:
Which do you consider to be the easiest to avoid or fix : Monroe and Cox provide eight pricing practices of companies that have a negative effect on profitability. Which do you consider to be the easiest to avoid or fix?

Reviews

Write a Review

Database Management System Questions & Answers

  What are the main activities that the business undertakes

What are the main activities that the business undertakes and where in the business are the crucial decisions made?

  Assignment on income support policies

In this assignment, you must examine the philosophical underpinnings of the economic system and its relationship to ethics and social justice by examining income support policies. You will also view the socially constructed ways of developing and ..

  Developing a use case diagram

Developing activity diagrams. (Please note that for the use case, "Buy Items", there are two scenarios, namely, "General public customer buys items" and "Contractor customer buys items". You should develop an activity diagram for each of the..

  Alexander, the great: strength, weakness and contributions

There were immense qualities for Alexander, the great as a leader. One of the greatest qualities a leader should have is ambition.

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Explain the security mechanisms available for a database

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

  Products under the traditional costing system

Determine the unit product cost of each of the company's two products under the traditional costing system

  You have been hired as the banks director of data security

a large bank has a headquarters location plus several branches in each city in a particular region of the country. as

  Design an relational model model of a database

Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises. (Hint: You may choose to translate the 2 ER model designs you created ).

  Write sql select statements to retrieve

How many models of the Titanic have been shipped? What was the date of the first shipment and when was the last shipment sent - Write SQL SELECT statements to retrieve

  Explore the database to understand what it is about

explore the database to understand what it is about then close your Microsoft Access

  Design a suitable database system

Design a suitable database system with a suitable web based front end, which should include the following details :The web based interface should hab=ve necessary forms and fields to update student attendence,marks ,faculty profile,faculty workshops ..

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!

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