B.C.A RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper - 2008

[ganeshbala]

B.C.A RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper - 2008 open university

RELATIONAL DATABASE MANAGEMENT SYSTEMS

Time : 3 hours Maximum marks : 75

Answer for 5 marks questions should not exceed 2 pages.

Answer for 10 marks questions should not exceed 5 pages.

PART A — (5 × 5 = 25 marks)

Answer any FIVE questions.
1. Discuss briefly about DBMS.
2. Discuss briefly about the steps involved in designing a database.
3. Discuss briefly the desirable properties of decompositions.
4. Define the following
(a) domain
(b) attribute
(c) primary key
(d) candidate key
(e) relational database.
5. Discuss briefly about Microsoft Access Database.
6. Discuss briefly how to set toolbars to our working style.
7. Discuss the benefits of conventional DBMS.

PART B — (5 x 10 = 50 marks)

Answer any FIVE questions.
8. Discuss in detail the advantages and disadvantages of using a database system.
9. Discuss in detail the components of an E_R diagram.
10. Explain in detail the various NORMAL FORMS.
11. Explain in detail about the objects of an Access Database.
12. Explain in detail how to create Tables using Microsoft Access Database.
13. Explain in detail how to create Forms using Microsoft Access Database.
14. Explain on views and security using SQL