Tamil Nadu Open University (TNOU) 2006 Post Graduate Diploma Computer Application M.C.A./P.G.D.C.A UARY, . - Question Paper

2044
MCA-04/PGDCA-03
M.C.A./P.G.D.C.A. exam JANUARY, 2006

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.