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
An orchestra database consists of the following relations: CONDUCTS (conductor, composition) REQUIRES (composition, Instrument) PLAYS (Player, Instrument) Give the relational

What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.

Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano

State your technical objectives for mining the data. Data Understanding. Describe the data For each attribute, give its description and data type. For numeric attributes