Tamil Nadu Open University (TNOU) 2006 M.C.A INTRODUCTION TO DATABASE MANAGEMENT SYSTEM - Question Paper

Tamil Nadu Open University Master of Computer Applications (MCA) - 2044 MCA-05/PGDCA-04 Introduction to Database Management System - January 2006
M.C.A./P.G.D.C.A. exam
First Semester

INTRODUCTION TO DATABASE MANAGEMENT SYSTEM
Time: three hours
Maximum marks for M.C.A: 60
Maximum marks for P.G.D.C.A: 75

JANUARY 2006

PART A - (5 x five =25 marks)
P.G.D.C.A. students should ans any 5 ques..
M.C.A. students should ans any 4 ques..

1. With a neat sketch explain the three-schema architecture of a DBMS.

2. describe cardinality ratio. explain the identical with relevant examples.

3. With an example explain index sequential file organization.

4. With an example explain the division operation in relational algebra.

5. Justify the need for normalization.

6. With an example explain generalization and specialization. Also state what inheritance is.

7. Compare and contrast file systems with database systems.

PART B - (5 x 10 =50 marks)
P.G.D.C.A. students should ans any 5 ques..
M.C.A. students should ans any 4 ques..

8. Perform a comparative study ranging from the hierarchical data model and relational data model.

9. With a relevant example explain the following:
(a) Ternary relationship.
(b) Unary relationship.
(c) Aggregation.

10. With relevant examples explain the various kinds of join operations in relational algebra.

11. explain with relevant examples the subsequent in SQL:
(a) GROP BY
(b) ORDER BY
(c) IN
(d) other than

12. Perform a comparative study ranging from Centralized databases and distributed databases.

13. What is a knowledge base management system? explain the identical with a relevant example.

14. define the multi key file organisation.

Earning:   Approval pending.