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

  Define database systems and discuss the purpose for choosing

You have been asked to explore three database alternatives for a merchant who provides shoes to retail stores. The merchant needs the database to keep the financial records, employee records, inventory records and general use records for the busin..

  What do you find most interesting in the failure stories

What generalizations apply across the cases? ?What do you find most interesting in the failure stories? ?Do they provide any insights about how a failure might be avoided

  Explain the purpose database design process

Explain why functional dependency is important in relational design. Database Design: Why go through the database design process? What are important issues during the design phase that impact the success of the database?

  Systems analysis and database designyou should back up your

systems analysis and database designyou should back up your answers with theoryreferences from reliable sources - more

  Describe type of replication

You should select Snapshot replication as the type of replication

  Designing a relational database

What are the main differences between designing a relational database and an object database. Illustrate by examples.

  Diagram of the table containing the initial data

Diagram of the table containing the initial data - state how you checked that the XML file is well-formed and what messages are sent if it is not well-formed?

  Explain fragmentation and replication

Define association rules, and explain how to induct association rules by using frequent itemsets, a Priori Property, and support and confidence measures.

  How would you change the current design

How would you change the current design and how does your new design address the problems you have identified with the current design.

  Probably its a quite simple problem to solve - but im not

i really would appreciate your help.probably its a quite simple problem to solve - but im not the one .. -i have two

  Oracle datatypes for attributes from a normalized relation

Choose Oracle datatypes for the following attributes from a normalized relation including: Vendor(VendorID, Address, ContactName) Item (ItemID, Description) PriceQuote(VendorID, ItemID, Price) Describe why you selected the datatypes for each attri..

  Explain data flow diagram

Which module actually contains the logic to call the Update Credit File Module?

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