DATABASE MANAGEMENT SYSTEM,2011 Question Paper, NCP,Madras University Question Paper

Madras University Question Paper
Subject : DATABASE MANAGEMENT SYSTEM
Subject Code : NCP
OCTOBER 2011 U/ID 14677/NCP
Time : Three hours Maximum : 100 marks
PART A — (5 × 8 = 40 marks)
Answer any FIVE questions.
All questions carry equal marks.
1. Briefly explain the data base components.
2. Explain the formal query languages with example.
3. Explain the basic structure of relational database
with example.
 4. Explain the declaration and usages of the PL/SQL
data types with example.
 5. Explain the advanced data management
commands and SQL functions.
6. Briefly describe the mapping constraints in
database system.
7. Explain how to create the multiple form
applications using developer 2000.
8. Briefly explain the canvases and views.
 Canvases ©ØÖ® viewsø¯ _¸UP©õP ÂÍUSP.
PART B — (3 × 20 = 60 marks)
Answer any THREE questions.
All questions carry equal marks.
9. Explain the components of E-R model and scheme
diagram in detail with example.
10. Explain any four basic relational-algebra
operations with example.
11. Explain the following :
 (a) Boyce-Codd Normal Form (BCNF) (10)
 (b) Normalization using multivalued
dependencies. (10)
12. Discuss the PL/SQL procedures and exception
handling with example.
13. Explain the following :
 (a) List boxes and Dialog boxes (10)
 (b) Event and triggers. (10)
——————— 

Share This