Annamalai University 2008-2nd Year B.C.A Computer Application " 630RELATIONAL DATABASE MANAGEMENT SYSTEM " (PART – III — -IX) 6685 - Question Paper
-2-
SECTION - B (3 x 20 = 60)
Answer any THREE Questions.
All question carry equal marks.
11. Explain the architecture of a database system in detail.
12. Give a detailed description about E-R diagrams. Also illustrate.
13. With suitable examples explain the retrieval operation methods.
14. Explain the first, second and third normal forms with examples.
15. Develop a students database of your own. Also write any five data manipulation statements using PL/SQL queries.
Name of the Candidate:
B.C.A. DEGREE EXAMINATION - 2008 SECOND YEAR
(PART - III PAPER-IX)
630. RELATIONAL DATABASE MANAGEMENT SYSTEM
(New Regulations)
(Including Lateral Entry)
Dec.) (Time: 3 Hours
Maximum: 100 Marks
SECTION - A (8 x 5 = 40)
Answer any EIGHT Questions.
All questions carry equal marks.
1. Draw a simplified diagram of a database system and explain its components.
2. With suitable illustration explain the importance of primary, secondary and foreign keys.
3. Discuss on three types of database schemes.
4. Give a note on traditional set operations.
5. Briefly discuss the SQL-QBE built in functions.
6. Write any five update operations with illustration.
7. Elucidate the concept of functional dependency.
8. Write about Boyce-Codd normal form.
9. State the advantage s of PL/S QL.
10. With an illustration, explain the PL/SQL block..
Attachment: |
Earning: Approval pending. |