A2-R3: BUSINESS SYSTEMS
: JULY 2004
NOTE:
1. There are TWO PARTS in this Module/paper. PART ONE contains FOUR questions and PART TWO contains FOUR questions.
2. PART ONE is to be answered in the TEAR-OFFANSWER SHEET only, attached to the question paper, as per the instructions contained therein. PART ONE is NOT to be answered in the answer book.
3. Maximum time allotted for PART ONE is ONE HOUR. Answer book for PART TWO will be supplied at the table when the answer sheet for PART ONE is returned. However, candidates who complete PART ONE earlier than one hour, can collect the answer book for PART TWO immediately after handing over the answer sheet for PART ONE.
TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE-40; PART TWO – 60)
PART ONE
(Answer all the questions)
1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1 x 10)
1.1 The objective of maintaining an inventory control operation is
A) To maximize the money invested
B) To reduce the cost of storing, handling and insuring a large quantity of goods
C) To search stock
D) None of the above
1.2 Which of the following is true 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 following 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 two 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 correct
D) None of the above is correct
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 selected work area using the key expression defined 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 correct
2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “tear-off” sheet attached to the question paper, following 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, each record can occupy only one detail line.
2.6 SORT ON NAME + AMOUNT TO BANK is a valid command
2.7 If a database file contains 5 fields, its structural compound index file can have a maximum of 5 index tags.
2.8 ALLTRIM() removes leading blanks from the specified character expression.
2.9 Consider the following 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 closest related meaning/ word(s)/phrases in column Y. Enter your selection in the “tear-off” answer sheet attached to the question paper, following 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 same 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 another database file
K. alternate name for a database file
L. restricts entry in a numeric field
4. Each statement below has blank space to fit one of the word(s) or phrases in the list below. Enter your choice in the “tear-off” answer sheet attached to the question paper, following 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 defined as a series of actions of operations, which convert data into useful information.
4.2 The __________ is used to define the structure of a database.
4.3 The ___________ enables users to define their requirements for extracting the desired information 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 start the Table Wizard, open the ________ option from the system menu and select Wizards. From the list select the Table Wizard.
4.8 If the table has no appropriate 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 ALL questions)
5.
a) What is business data processing?
b) State some of the advantages and disadvantages of getting the accounting data processed by a computer.
c) What are the main problems that can arise in capturing raw data for use within a computer system?
(5x3)
6.
a) What is meant by file organization? What are the three commonly used file organizations in business data processing? How do we decide to use a particular file organization for an application?
b) Distinguish between structure programming and modular programming.
(10+5)
7.
a) How information is stored by FoxPro?
b) What is a relational database system? Explain with example.
c) How does indexing works in Database?
(5x3)
8. Explain the following:
a) What is the purpose of SET FILTER command? Give 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 provided 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 read this file, calculate 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 information for each 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)
