(i) Draw a flowchart to show how SALESFILE is created by accepting data from the terminal for each record. The record consists of the code number of a salesperson, name of the person, and sales amount in a month. Write the algorithm of the solution. (ii) Consider SALESFILE from in problem 1. Construct a flowchart showing how a sales report is generated in the format outlined below:

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
(i) Draw a flowchart to show how SALESFILE is created by accepting data from the terminal for each record. The record consists of the code number of a salesperson, name of the person, and sales amount in a month. Write the algorithm of the solution. (ii) Consider SALESFILE from in problem 1. Construct a flowchart showing how a sales report is generated in the format outlined below:
Field
Data Type and Size
Part number
5 numeric positions
Part name
15 alphanumeric positions
Quantity in stock
5 numeric positions
Another data file named TRANSFL contains the records of transac-
tions on the items in the inventory. Each record of this file consists of
the following:
Field
Data Type and Size
Part number
5 numeric positions
Transaction code
1 numeric position
1 = receipt
2 = issue
Quantity transacted
5 numeric positions.
Draw a flowchart to show how the master file is updated on the basis of
the records of the transaction file. Develop an algorithm for the solu-
tion of the above problem.
Transcribed Image Text:Field Data Type and Size Part number 5 numeric positions Part name 15 alphanumeric positions Quantity in stock 5 numeric positions Another data file named TRANSFL contains the records of transac- tions on the items in the inventory. Each record of this file consists of the following: Field Data Type and Size Part number 5 numeric positions Transaction code 1 numeric position 1 = receipt 2 = issue Quantity transacted 5 numeric positions. Draw a flowchart to show how the master file is updated on the basis of the records of the transaction file. Develop an algorithm for the solu- tion of the above problem.
SALES REPORT OF XYZ LTD.
FOR THE MONTH OF DECEMBER 2019
SALES PERSON
SALES-
CODE
ΝΑΜΕ
АMOUNT СOMMISSION
SWAPAN
IOLO01
SEN
10,000
3,500
GRAND
ΤΟΤALS:
NET SALES:
AVERAGE NET
SALES:
A VERA GE
COMMISSION:
The rules for calculating the commission are as follows:
SALES
RATE
<= 5000
2% of SALES
> 5,000 but <=20,000
3.5% of SALES
> 20,000 but <= 50,000
5% + $1,000
> 50,000
7% + $2,500
Develop the algorithm of the solution.
(iii) A company maintains inventory data in a file named ITEMFL. The
master file is stored on part number and contains the following types of
data for each item held in the inventory.
Transcribed Image Text:SALES REPORT OF XYZ LTD. FOR THE MONTH OF DECEMBER 2019 SALES PERSON SALES- CODE ΝΑΜΕ АMOUNT СOMMISSION SWAPAN IOLO01 SEN 10,000 3,500 GRAND ΤΟΤALS: NET SALES: AVERAGE NET SALES: A VERA GE COMMISSION: The rules for calculating the commission are as follows: SALES RATE <= 5000 2% of SALES > 5,000 but <=20,000 3.5% of SALES > 20,000 but <= 50,000 5% + $1,000 > 50,000 7% + $2,500 Develop the algorithm of the solution. (iii) A company maintains inventory data in a file named ITEMFL. The master file is stored on part number and contains the following types of data for each item held in the inventory.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY