Kerala University 2006 M.C.A Computer Second Semester - Question Paper
Reg. No.:.....................................
Name:..................................................(Pages: 2) .7848
Second Semester M.C.A. Degree Examination, October 2006 BUSINESS DATA PROCESSING
Reg. No.:.....................................
Name:..................................................(Pages: 2) .7848
Time: 3 Hours Max Marks; 75
Instruction: Answer all questions from Part A and five questions from Part; B, one each from Unit I and III and three from Unit II.
i PART - A
1. Discuss the various techniques for data collection in a data processing system.
2. What do you mean by master files and transaction files ?
3. Define a file and a record.
4. Write COBOL statements for the following:
a) Add the value of BONUS to TOTAL JPAY.
b) Calculate DA which is 70% of Basic pay.
5. Discuss the important divisions in a COBOL program.
6. What do you mean by relational condition and class condition ?
A 7 What do you mean by data independence ?
8. Give examples of DML and DDL commands, (any two each)
9. What are the different date models ?
10. How is redundancy avoided in a database ?
PART - B UNIT - I
Answer any one :
11. Explain any one file recovery procedure.
12. Discuss the various steps in business data processing.
UNIT - II
Answer any three : .
13. Write a COBOL program which inputs 50 employee records as follows.
Column 1 - 10 |
Name |
11-15 |
Basic pay |
16 - 20 |
DA |
21 - 23 |
CCa |
24 - 28 |
Total pay |
Total pay = Basic pay + DA + CCa |
Print a report with the Heading Employee name Basic pay DA CCA Total pay and display all records.
14. The following table contains monthly sales data for the 12 months of a year and for the 4 sales zones where each zone has 8 districts.
01 SALES-TABLE
05 SALE-ZONE occurs 4 Times 10 SALE-DISTRICT occur 8 Times
15 SALE-DATA DIC 9 (5) occurs 12 times.
a) How is the sale value for the third zone, seventh district and fourth month referred to in the procedure division ?
b) What is the size of SALES-TABLE (in number of bytes) ?
15. Explain the COBOL constructs used for sorting a sequential file.
16. With the help of an example, explain how searching is performed on a TABLE.
17. What do you mean by modular programming ? What features of COBOL support this technique ?
UNIT - III
1 8. Explain the three level architecture of a data base system."
19. What are ER diagrams ? Illustrate with an example how they are used to design a database table.
Attachment: |
Earning: Approval pending. |