Solution-An electricity supply authority records on an

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?

User Account

All Pages

An electricity supply authority records on an electricity

Reference no: EM13945485

Reference no: EM13945485

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT