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.
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
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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F53d54b4f-daab-4cfc-96e7-e26cf058c42f%2F03d63dad-282b-4e8e-82e9-dd704d29a600%2Fjfs8m9e_processed.jpeg&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F53d54b4f-daab-4cfc-96e7-e26cf058c42f%2F03d63dad-282b-4e8e-82e9-dd704d29a600%2Fywjfqg8_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr