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 are the four main characteristics of the database approach? The four major characteristics of the database approach are: 1. Self-describing nature of a database system. 2.

We face problem of stock Opening balance and closing balance in Minus

Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w

I want to fragment existing table using java code... help me..!!

Write short notes on Schema diagram.  A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema  diagram. Every relation appea

Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.