Tamil Nadu Open University (TNOU) 2009-1st Year B.C.A Computer Application >>INTRODUCTION TO DBMS>>E .>> - Question Paper

B.C.A. DEGREE EXAMINATION
JUNE 2009.

First Year

INTRODUCTION TO DBMS

Time : 3 hours Maximum marks : 75

PART A (5 5 = 25 marks)

Answer any FIVE questions.

1.         Discuss about Entities, Attributes, Logical and Physical Data and schema.

2.         Write short notes on four techniques of file organization.

3.         Write the advantages of Btree indexes.

4.         Discuss about Integrity rules.

5.         What is Normalization? Explain modification anomalies with an example.

6.         Write the advantages of object oriented systems.

7.         Discuss about OLE and its advantages.

PART B (5 10 = 50 marks)

Answer any FIVE questions.

8.         Discuss in detail about DBMS structure.

9.         Explain about conversion of Hierarchical and Network structure into relation.

10.       Explain Sequential File Organisation.

11.       Explain about Joins, Selection, Projection and Division.

12.       Discuss about 1NF, 2NF and 3NF.

13.       Write in detail about components of client/Server computing.

14.       Explain features of a knowledge-based system.