Draw the flowchart for the decision structure

Assignment Help Database Management System
Reference no: EM13947832

A telephone company service plan charges 25 cents for each call made. In addition, it charges 5 cents a minute for all calls made to a phone number that has a service plan with the company. Or, if the call is to a phone that does not have a service plan with the company, it charges 15 cents a minute for calls that last less than 20 minutes or ten cents a minute for calls that last 20 minutes or longer. The phone company has a file with one record for every call made in one day. (In other words, a single customer might have many such records on file.) Fields for each call include customer area code (three digits), customer phone number (seven digits), called area code (three digits), called number (seven digits), a character to indicate whether the other phone number has a service plan with the company (y) or not (n), and call time in minutes (never more than 4 digits).

The company wants a report listing one detail line for each call, including the customer area code and number, the called area code and number, the minutes, and the total charge.

a) Create a decision table to use while planning the logic for this program.

b) Draw the flowchart for the decision structure required in this program.

c) Identify appropriate test values for the decision structure and submit the results of a desk check of the program.

Step 1 Create a decision table to use while planning the logic for this program. Specifically, you should:

1.list the conditions for the decision;

2.generate all T/F combinations for the conditions;

3.list the actions to be taken;

4.analyze each T/F combination and determine which, if any, of the actions should be taken.

Step 2 Draw a flowchart of the decision structure and statements used to calculate the total phone charges for this program.

Step 3 Use the conditions in the decision table to identify test values that will test each range of values defined in the decision structure. For example, a condition x > 2 indicates you need to test a value of x less than 2, x equals 2, and a value of x greater than 2.

Desk check each test value using your decision structure and statements used to calculate the total phone charges. Be sure to show your steps in the Word document.

Reference no: EM13947832

Questions Cloud

Summary of the eight steps in ethical decision-making model : Write a 3- to 4-page paper, including the following points: A summary of the eight steps in the ethical decision-making model proposed by Bush et al. (2006). A critical analysis of the ethical decision-making model (i.e., analyze the strengths and w..
Write a command to list all files in current directory : Rewrite the following sequence of commands using sort as a filter. The end result should be a single command line when you are done.
Give an estimate of this common popualtion variance : Give an estimate of this common popualtion variance by pooling the sample variances given. Give an estimate of this common population variance based on the variance of the sample means given.
How your own values and personal beliefs will impact the way : xplain how your own values and personal beliefs will impact the way in which you view some of a client's behaviors, thoughts, or emotions as being normal or abnormal. Use examples to illustrate your ideas
Draw the flowchart for the decision structure : Identify appropriate test values for the decision structure and submit the results of a desk check of the program.
What is the value of j : Find the value of J in the given problem. Square root of j + square root of j +14 = 3 square root j +10. what is the value of J?
What is the total life-cycle profit desired for new model : What is the total life-cycle profit desired for the new model? What is the projected life-cycle profit for the new model?
Calculate the minimum salary for all employees. : Write SQL SELECT, UPDATE, and DELETE statements.
Explain how the revenue growth strategy can be tested : Explain how the revenue growth strategy can be tested. In your explanation, discuss the role of lead and lag measures, targets, and double-loop feedback.

Reviews

Write a Review

Database Management System Questions & Answers

  Create an employee database

Create a report that contains the above data - be sure to include a Hampton University logo in your report.

  Develop two select commands for each table

Develop two SELECT commands for each table. One of the commands for each table should use a WHERE clause to filter the records being returned.

  Identify entity types and their attributes

Identify entity types and their attributes, including the primary keys. Make sure that all your entities and your designed database is in third normal form.

  1 which is not a factor to consider in software evaluationa

1. which is not a factor to consider in software evaluation?a. performance effectivenessb. performance efficiencyc.

  Edinburgh airport officials are concerned about complaints

edinburgh airport officials are concerned about complaints received by the service department and are about to do an

  Complete a modified data dictionary for specialized register

Complete a modified data dictionary for a specialized registry/database for a disease or condition described in one of the scenarios that i will give to you

  Design a database schema1 patient-patientid name dob2

design a database schema1 patient-patientid name dob2 doctor-doctorid name medlicensenumber phone3

  Data warehouses and employee privacy

What should a company consider installing on the network perimeter to prevent direct connections between the internal network and the Internet to help protect its data warehouses and employee privacy

  Create a simple query for each table that returns

Create a simple query for each table that returns all of the columns and all of the rows for each table. Write a query that displays each part that has been purchased by Huffman Trucking Company

  Investigate current trends in using information systems

Evaluate the suitability of information systems for different functional areas of the organization - Investigate current trends in using information systems

  Explain relational database design

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

  Write an anonymous block that places a substitution variable

Write an anonymous block that places a substitution variable (&) into a local variable of type varchar2. You will need to convert the types and round them to nearest tens unit

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