Tamil Nadu Open University (TNOU) 2009-2nd Year B.C.A Computer Application " RELATIONAL DATABASE MANAGEMENT SYSTEMS " UG 420 09 - Question Paper
UG-420 BCA-09
U.G. DEGREE EXAMINATION JANUARY, 2009.
(AY 2004-05 batch onwards)
Second Year
B.C.A.
RELATIONAL DATABASE MANAGEMENT SYSTEMS
Time : 3 hours Maximum marks : 75
Answer for 5 marks question should not exceed 2 pages.
Answer for 10 marks questions should not exceed 5 pages.
PART A (5 x 5 = 25 marks)
Answer any FIVE questions.
1. Discuss briefly about Data Dictionary.
2. Discuss Primary key and Foreign key constraints with examples.
3. Discuss briefly the desirable properties of decompositions.
4. What is Normalisation? Write short notes on 3NF.
5. Discuss briefly about the objects of Access Database.
6. Discuss briefly how to set toolbars to our working style.
7. Discuss briefly multivalued dependency.
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. Explain the building blocks of an ER Model.
10. Explain in detail first normal form and second normal form.
11. Explain in detail how to create Tables and Forms using Access Database.
12. Discuss how to select, resize, move and delete Controls.
13. Explain in detail how to create Report using Access Database.
14. Explain on views and security using SQL.
2 UG-420
Attachment: |
Earning: Approval pending. |