Tamil Nadu Open University (TNOU) 2009-2nd Year B.C.A Computer Application .>>RELATIONAL DATABASE MANAGEMENT SYSTEMS>>E .>> - Question Paper

B.C.A. DEGREE EXAMINATION
JUNE 2009.

Second Year

RELATIONAL DATABASE MANAGEMENT SYSTEMS

Time : 3 hours Maximum marks : 75

PART A (5 5 = 25 marks)

Answer any FIVE questions.

1.         Define DBMS. List out the capabilities of DBMS.

2.         Write short notes on Domain Integrity and Entity Integrity.

3.         Discuss the anomalies present in repetition of information.

4.         Write down the steps of Bernstein's Algorithm.

5.         What is a Table? How will you create it?

6.         Explain about Set Field properties.

7.         What is join operation? Provide a sample query and explain it.

PART B (5 10 = 50 marks)

Answer any FIVE questions.

8.         Explain the benefits of Conventional or Centralized DBMS.

9.         Explain in detail about Views.

10.       With relevant example discuss the second and third normal form.

11.       Briefly explain multivalued dependencies and normalisation using Dependencies.

12.       Explain the commands used to retrieve, insert, delete and update tables.

13.       Explain how you will customize a form.

14.       Explain the steps in creating a report.