DOEACC Society 2007 Advanced Level Course In Computer Science A2-R3: BUSINESS SYSTEMS - Question Paper

C_ADRS Char 10 Customer's Address
C_PHONE Char 10 Customer's Phone Number
AMT_DUE Char 9 2 Amount Due
AMT_DEP Char 7 2 Amount Deposited
AMT_WITH Char 7 2 Amount Withdrawn
DATE Char 8 Date of transaction
D_DATE Char 8 Due Date
M_DATE Char 9 Maturity Date

Write a program in Visual FoxPro for the company to obtain the info about any existing customer by entering the customer number with proper windowing facility.
(15)

8. In a Payroll system, you are given with Employee number, employee name, Department, Designation, City which is either a Metro or an Non-Metro and Basic pay. Write a Visual FoxPro program to learn this file, compute allowances and total salary as follows:

a) Dearness allowance (DA)–

Up to Rs. 3500 110% of basic pay
Above Rs. 3500 90% of basic pay subject to minimum of Rs. 3850 and a maximum of Rs. 6300

b) House Rent allowance (HRA) is 15% of the basic pay subject to a maximum of Rs.800.
c) If City is Metro, City Compensatory Allowance (CCA) = 800 else if it is non-Metro, City Compensatory Allowance (CCA) = 600
d) Provident fund PF) is 12% of the basic pay.
e) Total salary=Basic Pay+Dearness Allowance+House Rent Allowance+CCA– PF
Each payslip printed should contain all info of input record, all allowances, deductions and total salary for every employee.
(15)

A2-R3: BUSINESS SYSTEMS

NOTE:
1. There are 2 PARTS in this Module/paper. PART 1 contains 4 ques. and PART 2 contains 4 ques..

2. PART 1 is to be answered in the TEAR-OFFANSWER SHEET only, attached to the ques. paper, as per the instructions contained therein. PART 1 is NOT to be answered in the ans book.

3. Maximum time allotted for PART 1 is 1 HOUR. ans book for PART 2 will be supplied at the table when the ans sheet for PART 1 is returned. However, candidates who complete PART 1 earlier than 1 hour, can collect the ans book for PART 2 immediately after handing over the ans sheet for PART ONE.
TOTAL TIME: three HOURS TOTAL MARKS: 100
(PART ONE-40; PART 2 – 60)

PART ONE
(Answer all the questions)

1. Each ques. beneath provide a multiple option of ans. select the most improper 1 and enter in the "tear-off" ans sheet attached to the ques. paper, subsequent instruction therein. (1 x 10)

1.1 One of the field names listed beneath is incorrect. It is
A) First_Name
B) FirstName
C) First Name
D) Firsrt_Nome

Earning:   Approval pending.