NOTE: There are 11 Questions in all.
Question 1 is compulsory and carries 16 marks. Answer
to Q. 1. must be written in the space provided for it in the answer book
supplied and nowhere else.
Answer any THREE Questions each from Part I and Part
II. Each of these questions carries 14 marks.
Any required data not explicitly given, may be suitably
assumed and stated.
Q.1 Choose the correct or best alternative in
the following: (2x8)
a. Managers at lower operating levels need information to
(A) support policy decisions.
(B) to make day to day operating decisions.
(C) support long range planning decisions.
(D) to take strategic decisions.
b. Information is
(A) data. (B) processed data.
(C) textual form of data. (D) none of these.
c. Top level managers use
(A) strategic information. (B) technical information.
(C) operational information. (D) none of these.
d. File is a collection of
(A) data. (B) attributes.
(C) relations. (D) records.
e. A sequential file organization is most suited for
(A) airlines information system. (B) hospital information system.
(C) a pay-roll system (D) library system.
f. A flow chart is
(A) a set of logical steps to solve a problem.
(B) a pictorial representation of an algorithm.
(C) a set of statements.
(D)
none of these.
g. DBMS stands for
(A) Data Business Manipulation System.
(B) Direct Business Management System.
(C) Data Base Management System.
(D) Data Business Management System.
h. Major advantage of distributed data process accrues because of
(A) reduced redundancy. (B)
coordinated information.
(C) relations. (D) records.
Answer any THREE Questions. Each question carries 14 marks.
Q.2 a. What are the different levels of management?
Explain briefly each one of them.
(7)
Q.3 a. What is a computer program? What is its function? Describe various types
of instruction in a computer program. (7)
b. Distinguish between testing and debugging. Classify different kinds of
program errors. (7)
Q.4 a. Describe briefly sequential file organization. Explain with examples the process of file maintenance. (10)
b. Distinguish between master file and transaction file. (4)
Q.5 a. Distinguish between Data Base Management
System and File Management System. (7)
b.
Describe briefly various components and activities of a
Data Base Management System. (7)
Q.6 a. Explain the use of various flowchart
symbols. Draw a flowchart to find the sum of first 100 odd natural numbers. (7)
b. Explain the use of Backups in data security. What is grandfather-
father-son technique ? (7)
Answer any THREE Questions. Each question carries 14 marks.
Q.7 a. What do you understand by structured programming? What are its advantages? (7)
b. What is the difference between Compiler and Interpreter? Give Examples.
(7)
Q.8 a. Describe main features of FoxPro. Explain the
function of catalog manger and menu system. Describe the features of a FoxPro
report. (9)
b. Describe various data types (fields) available in FoxPro. Which fields will be more appropriate to store the following information in a database file?
(i) Name of project.
(ii) Unit sale price.
(iii) Employee code.
(iv) Sex.
(v) Interest rate. (5)
Q.9
a. What is
batch processing? Give Examples. (7)
b. Write short notes on software utilities. (7)
Q.10 An inventory master file is sorted on disk as a sequential file with Part_No.as the key. The structure of record is: (14)
|
Field |
Type |
Size |
|
Part_No. |
N |
4 |
|
Part_disc. |
C |
20 |
|
Qty_on_hand |
N |
4 |
|
Per_unit_Price |
N |
5, 2 |
|
Re_order_Point |
N |
3 |
|
Re_order_Qty |
N |
3 |
|
Qty_on_Order |
N |
3 |
The transaction file is also sorted on Part_No. as
key and its format is
|
Field |
Type |
Size |
|
Part_No. |
N |
4 |
|
Qty |
N |
3 |
|
Code |
N |
1 |
If the code in the transaction record is 1 then the quantity is to be added to the inventory file and if the code is 0 the quantity is to be subtracted. When a re-order point is reached, the program should note the item involved and print a suitable message to store, also indicating the status of inventory, giving details of Part-no, Part description, Re-order level and Instore-qty.
Write a complete FoxPro program to update master file using transaction files and with the above conditions.
Q.11 a. Write
short notes on Auditing of computer system-indicating various methods used in
the process. (7)
b.
Distinguish between bottom up approach and top down approach for the
development of MIS. (7)