Develop a flowchart using the decision structure, Database Management System

1.  Develop a flowchart using the decision structure to solve the following problem.

A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches. One comes with a sandwich, cookies, and chips. The other comes with a sandwich, carrot sticks and a piece of fruit. The second box lunch is 1 ½ times as much as the first.

A program accepts the following data from a customer: name, address, phone number and how many of each type of box lunch they desire. They also indicate whether this is a government office (G), a corporate office (C), or a private party (P). Government offices receive a 10% discount on all orders. Private parties receive a 10% discount for orders totaling more than 50 box lunches. The output of the program prints the customer information, the order detail, and a total amount due upon delivery.

Rework Problem 1 above using a CaseOf instruction.

 

Posted Date: 3/12/2013 3:33:25 AM | Location : United States







Related Discussions:- Develop a flowchart using the decision structure, Assignment Help, Ask Question on Develop a flowchart using the decision structure, Get Answer, Expert's Help, Develop a flowchart using the decision structure Discussions

Write discussion on Develop a flowchart using the decision structure
Your posts are moderated
Related Questions
What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c


Define null values. In some cases a certain entity may not have an applicable value for an attribute or if we do not know the value of an attribute for a certain entity. In the

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

Problem 1. Write the SQL queries using Data Manipulation Language (DML) statements. Insert values into student table with field names using insert command Display the

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to