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

C) To search stock
D) None of the above

1.2 Which of the subsequent is actual about a disk file where WRITE statement will always place a record in the next physical position?
A) Sequential file
B) Relative file
C) Indexed file
D) None of the above

1.3 The most efficient and well designed computerized payroll system would be
A) On-line real time system
B) Batch processing system
C) Both A) and B)
D) None of the above

1.4 Purchases from suppliers is part of
A) Subsidiary ledger
B) Payroll transaction file
C) Balance sheet
D) Sales register










1.5 If AGE and SALARY are numeric fields in a database file, which of the subsequent commands in incorrect?
A) REPLACE ALL AGE WITH AGE+1 FOR AGE < 20
B) REPLACE ALL AGE WITH AGE+1 WHILE AGE > 20
C) REPLACE AGE WITH AGE+1 WHILE AGE < 20 ALL
D) All of the above

1.6 The command to create a new database file based on 2 open database files is
A) SET RELATION
B) UPDATE
C) JOIN
D) None of the above

1.7 ROUND( ) function is
A) A numeric function
B) Used to round a number to a specified number of decimal places
C) Both A) and B) above are accurate
D) None of the above is accurate

1.8 ? STUFF (“Baby”,3, 2,”ba”) returns
A) baby
B) baba
C) Baba
D) Bob

1.9 The command WAIT
A) causes all FoxPro processing to pause until any key is pressed
B) permits usage of a prompt which must be a character expression
C) has a default prompt which is “Press any key to continue…”
D) all of the above

1.10 The command REINDEX will
A) Rebuild all open index files in the currently opted work area using the key expression described by the original INDEX command
B) Rebuild all the index files on the hard disk
C) Rebuild all the index files in a particular directory
D) Both B) and C) above are accurate























2. Each statement beneath is either actual or FALSE. select the most improper 1 and ENTER in the “tear-off” sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

2.1 Structured programming diminishes the efficiency of coding of programs.
2.2 A purchase transaction increases the liability of a company.
2.3 Invoice detail file is a master file in a sales invoicing system.
2.4 In indexed sequential operation, records are held in sequential order on the disk and the index is kept permanently on the main storage for fast access.
2.5 While creating a report with CREATE REPORT, every record can occupy only 1 detail line.
2.6 SORT ON NAME + AMOUNT TO BANK is a valid command
2.7 If a database file contains five fields, its structural compound index file can have a maximum of five index tags.
2.8 ALLTRIM() removes leading blanks from the specified character expression.
2.9 Consider the subsequent code:
X=”Hello! How are you?”
? LEN(X)
It will return the value as 16.
2.10 A task started within DO WHILE and ENDDO loop will be continued until the condition is satisfied.

3. Match words and phrases in column X with the nearest related meaning/ word(s)/phrases in column Y. Enter your selection in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

X Y
3.1 Zero inventory level A. programming aid
3.2 pseudocode B. warning signal
3.3 Re-order level C. sends to printer
3.4 ??? D. displays in the identical line
3.5 VAL( ) E. low inventory storage
3.6 TRANSFORM( ) F. it is a numeric function to change character strings to numeric
3.7 IFF( ) G. provides a picture formatting to the numeric output
3.8 RANGE H. results in compactness in the program code
3.9 ALIAS I. copies the contents of previous record to the text
3.10 SET CARRY ON J. links the active database file to a different database file
K. alternate name for a database file
L. restricts entry in a numeric field












4. Each statement beneath has blank space to fit 1 of the word(s) or phrases in the list beneath. Enter your option in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

A. query language B. fields C. data processing
D. report generator E. tools F. data definition language
G. RETURN H. LOCATE I. data manipulation language
J. transaction file K. SEEK L. close database/use

4.1 __________ is described as a series of actions of operations, which convert data into useful info.
4.2 The __________ is used to describe the structure of a database.
4.3 The ___________ enables users to describe their requirements for extracting the desired info from the database in the form of queries.
4.4 The ________ enables the users of a database to design the layout of a report in the desired format.
4.5 A(n) ________ is used to store input data until it can processed.
4.6 ________ is the basis of FoxPro’s indexes.
4.7 To begin the Table Wizard, open the ________ choice from the system menu and choose Wizards. From the list choose the Table Wizard.
4.8 If the table has no improper indexes, you have to use ________.
4.9 The ________ command is used to close a database file in use.
4.10 Each function should end with a(n) ¬__________ statement.






















PART TWO
(Answer any 4 questions)

5.
a) What is business data processing?
b) State a few of the advantages and disadvantages of getting the accounting data processed by a computer.
c) What are the main issues that can arise in capturing raw data for use within a computer system?
(5x3)

6.
a) What is meant by file organization? elaborate the 3 commonly used file organizations in business data processing? How do we decide to use a particular file organization for an application?
b) Distinguish ranging from structure programming and modular programming.
(10+5)

7.
a) How info is stored by FoxPro?
b) What is a relational database system? discuss with example.
c) How does indexing works in Database?
(5x3)

8. Explain the following:
a) What is the purpose of SET FILTER command? provide an example.
b) What do you understand by object linking and embedding?
c) Explain Query designer and Multiple tables.
(5x3)

9.
a) Explain the IIF( ) function with an example.
b) In a Payroll system, you are given with Employee number, Employee name, Department, Designation, City which is either a Metro or a Non-Metro and Basic pay. Write a FoxPro program to learn this file, compute allowances, total income and net salary as follows:

i. Dearness Allowance (DA):
Up to Rs. 8000 60% of basic pay
Above Rs. 8000 50% of basic pay
ii. If city is Metro, House Rent allowance (HRA) is 30% of basic pay else if it is non-metro, HRA is 15% of basic pay.
iii. City compensatory allowance (CCA) is Rs.300
iv. Provided fund is 6% of the basic pay.
v. Total income = Basic pay + DA+HRA+CCA and
Net Salary = Total income – PF

Each payslip printed should contain the info for every employee as per the sample payslip output below:










PAYSLIP

Employee # : 7567 Department: COMPUTER
Employee Name: RAJ Designation: LECTURER


Payslip for the month of: December, 2003


INCOME Rupees

Basic Pay 6000
Dearness Allowance 3600
HRA 1800
CCA 300
-------------------------------------------------------------------------------------------------------------------------------------
Total Income 11700
-------------------------------------------------------------------------------------------------------------------------------------
DEDUCTIONS
-------------------------------------------------------------------------------------------------------------------------------------
PF 360
-------------------------------------------------------------------------------------------------------------------------------------
Net Salary 11340
-------------------------------------------------------------------------------------------------------------------------------------

ACCOUNT OFFICER

(5+10)

Earning:   Approval pending.