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 cus- tomers, 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 pay- ments. Each record in this file lists the customer's identification num- ber, 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.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter11: Sql Server Databases
Section: Chapter Questions
Problem 2E
icon
Related questions
Question
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 cus-
tomers, 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 pay-
ments. Each record in this file lists the customer's identification num-
ber, 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.
Transcribed Image Text: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 cus- tomers, 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 pay- ments. Each record in this file lists the customer's identification num- ber, 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.
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
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. (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
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
C-string
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr