Monday, January 4, 2016

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

Madras University Question Paper
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
Previous Post
Next Post

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!


Pen down your valuable important comments below

Search Everything Here