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: Continuation of the picture: The records have been kept sorted in ascending sequence of the Invoice Number. Accumulate the totals of the Gross Value, Discount, Sales Tax, and Net Payable amounts, and print the totals. Draw a flowchart showing the processing logic and write the algorithm of the solution. (v) A credit bureau maintains a master file that lists for, each of its customers, a unique identification number, name, current principal that the customer owes, and his or her credit limit. The credit bureau also maintains a transaction file that tracks its customers’ loans and payments. Each record in this file lists the customer’s identification number, together with the transaction’s amount and its date. A positive number indicates a payment and a negative number indicates a loan. Once a month, the credit bureau updates its master file by processing entries in the transaction file. Assume that the master file records are sorted by identification number, but the transaction file is not sorted. Construct a flowchart and then develop the algorithm showing the program logic to update the master file.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

(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: Continuation of the picture: The records have been kept sorted in ascending sequence of the Invoice Number. Accumulate the totals of the Gross Value, Discount, Sales Tax, and Net Payable amounts, and print the totals. Draw a flowchart showing the processing logic and write the algorithm of the solution. (v) A credit bureau maintains a master file that lists for, each of its customers, a unique identification number, name, current principal that the customer owes, and his or her credit limit. The credit bureau also maintains a transaction file that tracks its customers’ loans and payments. Each record in this file lists the customer’s identification number, together with the transaction’s amount and its date. A positive number indicates a payment and a negative number indicates a loan. Once a month, the credit bureau updates its master file by processing entries in the transaction file. Assume that the master file records are sorted by identification number, but the transaction file is not sorted. Construct a flowchart and then develop the algorithm showing the program logic to update the master file.

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.

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.
(iv) A data file contains invoice records. The layout of the records is given
below:
Field
Data Type and Size
Party Code
5 alphanumeric
Invoice Number
6 Numeric
Invoice Data
6 ( DD MΜM YY)
Gross =Value
$7 & cents
Discount Amount
$6 & cents
Sales Tax Amount
$7 & cents
Net Payable
$7 & cents

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions