Punjab University 2008 B.C.A Computer Application Data Processing System - Question Paper

DATA PROCESSING SYSTEM

Time allowed: three Hours

Max. Marks: 90

ATTEMPT 5 ques. IN ALL,SELECTING 2 ques. every FROM part - A AND part – B .SECTION C IS COMPULSORY.

part - A

1. (a) explain the relationship, if any, among characters, records, data-items, files and databases with the help of an example. (4)

(b) discuss the differences ranging from business and scientific data processing in brief. (4)

(c) discuss the characteristics of software requirements specifications. Also discuss its role in the software development cycle. (10)

2. (a) What is data dictionary? What is dat6a floe diagram? discuss with the example. (8)

(b) explain the different activities at the design phase in detail.

3. (a) Why do we test system? How important is testing? A variety of tests are used to test systems. explain these tests in brief. (10)

(b) What do you mean by software maintenance? discuss the various kinds of software maintenance in detail.(8)

4. Write short note on following:

(a) different methods of software implementation

(b) Integrated Case Tools

(c) Characteristics of a good programming

(d) Debugging.

part – B

5. What do you understand by MIS? discuss the structure and classification of MIS. Also discuss the role and importance of MIS in management function and decision making in any organization. (18)

6. (a) discuss the 3 schema architecture of a DBMS wit6h the help of diagram. Why do need mappings ranging from the various schema levels? Also discuss the advantages and disadvantages of DBMS. (12)

(b) What is RDBMS? Why relational data model is better than other data Models? discuss. (6)

7. (a) What is Normalization? discuss all kinds of normal forms with the help of suitable examples. (10)

(b) What do you mean by E-R diagram? Draw an E-R diagram by taking your own example (8)

8.(a) discuss the different data kinds in FoxPro with example.(6)

(b) discuss the different facilities available in FoxPro with examples for querying a database. (6)

(c) describe Table and Indexes with examples in FoxPro. (6)

part – C (COMPULSORY QUESTION)

9. discuss the subsequent in brief: (18)

(a) different data processing operations.

(b) Compilers ,Linkers and Editors

(c) Responsibilities of DBA.

(d) Difference ranging from Top down and Bottom up approach of designing a software.

(e) Full/partial/transitive dependencies

(f) Difference ranging from logical and physical data independence

(g) Editing a database in FoxPro.

(h) What is Data Redundancy?

(i) Documentation tools.

Earning:   Approval pending.