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.

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

Similar questions

Can any body help with nested record program?
Question 1: Create a structure to specify data of employees in CS Department. The data to be stored is: Employee ID, Name, designation, Date of Joining and a flag to know whether the current employee is still in service or not. Assume maximum of 20 employees in the CS Department. Your program must be menu driven with following options: 1. Add a record (Employee ID, Name, Designation and Date of Joining of each employee) 2. Print the Employee ID, Name, Designation, Date of Joining and Status (whether the employed still in service or left) of each employee in tabular format. 3. Search specific employee. 4. Calculate total service of each employee.
Vocabulary Task (C language) Solution given below. How to fix the error in the picture attached. txt file is not being created from this code please also include how to create a txt file and where will it be saved in the computer Natural language processing (NLP) is a field of artificial intelligence that seeks to develop the ability of a computer program to understand human language. Usually, the first step of an NLP system is to convert words into numeric codes. Thus, the system converts an input text into a sequence of numeric codes before any high-level analysis. This process is known as text preprocessing. We can only perform text preprocessing if we have a vocabulary of words and their associated numeric codes. Your task is to create a vocabulary of unique words for a given text file and assign a different number from 1 to N to each unique word, with N being the total number of unique words. You must perform this assignment so that the first word in alphabetical order gets the…
The GTUC Company wants to produce a product orders report from its product orders file. Each record on the file contains the product number of the item ordered, the product description, the number of units ordered, the retail price per unit, the freight charges per unit, and the packaging costs per unit. Your algorithm is to read the product orders file, calculate the total amount due for each product ordered and print these details on the product orders report.The amount due for each product is calculated as the product of the number of units ordered and the retail price of the unit. A discount of 10% is allowed on the amount due for all orders over 100.00. The freight charges and packaging costs per unit must be added to this resulting value to determine the total amount due.
v. Display only the StudentID, Programming Score and the Maths Score. vi. Show records of students with ID numbers from BIT2016003 to BIT2016005 vii. Select records of students who scored below 70 in Maths. viii. Insert the sixth record with Student ID=BIT2016006, First name =Gabriela, Surname = Yeboah, Maths =82, French=79 and Programming=58. ix. Select student(s) whose first name begins with the letter “J”. x. Delete student whose ID = BIT2016004 xi. Remove the surname column from the table xii. Change the French score to 79 for Student ID = BIT2016002 xiii. Remove the Student table from the database xiv. Remove MySchool database from the computer
Given the following table: Student ( id, first_name, last_name, address, program, phone), which of the following statements will list the number of students who are in IT program? a. select max(*) from student where program = 'IT'; b. select sum(*) from student where program = 'IT'; c. select count(*) from student where program = 'IT'; d. select count(program) from student where program = 'IT'; One of the following is not directly supported in PL/SQL blocks a. delete b. alter c. update d. insert Which of the following is not a correct variable declaration in PL/SQL? a. college varchar2(20) ; b. college varchar2(20) = 'Sur' c. college varchar2(20) := 'Sur'; d. college varchar2(20) not null; In handling foreign key violations, the option to reject if the row is referenced in another table is .... a. Cascade b. Set null c. set default d.…
a) Find names and surnames of professors who teach a course in the "Biology" program: π(first_name, last_name)(σ(course_name = "Biology")(Course ⨝ Professor)) b) Find the student IDs and names of students who have not taken any exam (from any course): π(student_id, first_name, last_name)(Student - π(student_id)(Exam)) c) Find student IDs of students who have passed every exam from the "Data Science" program: π(student_id)(Student ⨝ (σ(programme = "Data Science")(Course) ⨝ (Student.student_id = Exam.student_id) ⨝ (Exam.grade >= 5))) d) Find the course IDs and names of courses that have been passed by at least two different students: π(course_id, course_name)(Course ⨝ Exam) ÷ ρ(count(students_passed), count(students_passed)(Course ⨝ Exam)) do these solutions fulfil these requirements 2. Use RELATIONAL ALGEBRA to write the following queries:a) Find names and surnames of professors, who teach a course in "Biology" programmeb) Find the student IDs and names of students who have not…
You are given a list of courses that are currently available in Oxford College that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate or masters students. Write a python program that creates a dictionary from the above list where the keys will be each department name (CSE,EEE,MAT for the above example) and their values will be a dictionary of two keys - Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively. Sample Input - No need to take input ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510'] Sample Output: (You just have to print the resultant dictionary. No need to follow the pattern below) { 'CSE':{ 'Undergraduate':['CSE110','CSE111'], 'Graduate':['CSE520','CSE650'] },…
Create a flowchart for borrow and return history
6. SELECT e.Last_Name, m.Last_Name AS "Manager Name", e.Salary*12 AS "Annual Salary", 1.City FROM employees e JOIN employees m ON e.Manager_id = m.Employee_Id JOIN departments d ON d.Department_id = e.Department_Id JOIN locations 1 ON 1.Location_id = d.Location_id WHERE 1.City = "California"
The system to be developed for Williams and Son needs to produce the following slip for a customer once the sale has been concluded. Williams & Son VATnr: 0123456 Product Price Screwdriver R 100 Super glue R 20 Total: R120 Please note: For the purpose of this assignment, assume that a customerwill only purchase one unit of each item.
1: Write a stored procedure which takes Cid from user and return the Product of That Category.