Tamil Nadu Open University (TNOU) 2006 B.C.A Computer Application -06 INTRODUCTION TO DBMS - - Question Paper

TAMILNADU OPEN UNIVERSITY

BCA DEGREE exam - JUNE 2006

BCA-06 INTRODUCTION TO DBMS

UG-719    BCA-06

B.C.A. DEGREE EXAMINATION - JUNE 2006. First Year (For Candidates admitted in 2004-05, CY 2005 and 2005-06) INTRODUCTION TO DATA BASE MANAGEMENT SYSTEMS

Time : 3 hours    Maximum marks : 75

PART A (5 x 5 = 25 marks)

Answer any FIVE questions.

1.    Discuss the advantages and disadvantages of DBMS.

2.    Discuss the different views and levels of architecture for a DBMS.

3.    Discuss briefly the Sequential File Organisation.

4.    Explain briefly the structure of Relational Database.

5.    Discuss briefly the basic structure of an SQL Expression with an example.

6.    Discuss briefly Knowledge Base Management System.

7.    Discuss the pros and cons of Object Orientec DBMS.

PART B (5 x 10 = 50 marks)

Answer any FIVE questions.

8.    Explain in detail the various Database Models.

9.    Explain the different types of File Organisations.

10.    Explain the pitfalls in Relational Database Design with an example.

11.    Discuss INF, 2NF, 3NF, BCNF with an example.

12.    Explain the structure of DBMS.

13.    Define KBMS. Discuss in detail the importance of KBMS.

14.    Explain in detail Client Server Systems.

2    UG-719

Attachment: tamil-nadu-open-university--tnou--2006-b-c-a-computer-application-48877-1.pdf

Earning:   Approval pending.