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

4.3 Purchases from the vendors form part of_________.
4.4 After every year we need to begin with the__________ afresh.
4.5 To establish a link ranging from 2 database files, the________ command can be used.
4.6 Schedules to _________ show detailed info regarding the working of the company.
4.7 The approach towards program design in which main program is decomposed into progressively lower level modules is called________.
4.8 Debits and credits must be__________ in a double entry book keeping system.
4.9 Detailed design logic of an application, developed using a package, can be represented by_________.
4.10 _________ allows decision makers to measure, interpret, analyze and communicate financial info.
























PART TWO
(Answer any 4 questions)

5. Answer any 3 of the subsequent in not more than 100 words:
a) Describe briefly with an example, the difference ranging from change and UPDATE.
b) What is the purpose of DO WHILE command? discuss its 2 choices EXIT and LOOP.
What is the various ranging from DO WHILE .T. and DO WHILE .NOT. EOF()?
c) Differentiate ranging from Real Time and Online processing. provide 1 example of every kind.
d) What is the various obtain and SEEK. provide 1 example of every kind.
(5 x3)

6. Answer any 3 of the following:
a) Using Visual FoxPro write a program that will calculate rebate and print an output comprising of 3 things - Customer Identification number, Purchase Amount and Rebate for every record. The customer identification number is given to you along with the Purchase amount and the slabs of rebate. Use the table listed below:

Amounts of Purchase Rebates applicable on purchase amounts
>= Rs. 5000 6%
> Rs. 5000 but<= Rs. 10000 9%
> Rs. 10000 12%

b) A database table called PAYROLL contains the fields EMPNAME, BASICSAL and ALLOWANCES. Write a program to print a report with Name and Total salary (BASICSAL+ALLOWANCES) is more than 20000. At the end of the program you should also print a total number of employees whose Total salary is more than 20000.

c) Write a program to compute the telephone bill. every time when the program is run, it should 1st ask for the program 1st ask for the number of calls made and then print the amount payable as per the subsequent rules:

- First 200 calls are free
- Next 100 calls @Rs. 1.80 per call
- And the next calls @ Rs. 2.30 per call

d) Blue chip Company keeps a record of their employees in a table by the name PERS.DBF. The structure of the table is an under:

Earning:   Approval pending.