B.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Third Semester
Computer Science
DATABASE MANAGEMENT SYSTEMS
(CBCS 2011 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is database system?
2. Write any two E-R design issues.
3. What is normalization?
4. What is functional dependency?
5. Define transactions.
6. State the benefits of distributed transactions.
7. What is Data Integrity?
8. Define View.
9. Write the benefits of Stored procedure.
10. State the uses of Packages.
Sub. Code
1BCE3C1
AFC-10384
2
WS3
Part B x 5 25)
Answer all questions, choosing either or
11. Describe the semi structured databases in detail.
Or
What is E-R model? Explain its components of it.
12. Write a short note on First Normal form.
Or
Illustrate about the functional dependency theory.
13. Elucidate the Server system architecture in detail.
Or
Briefly discuss about Distributed systems.
14. Explain the procedures to create Indexes with an
example.
Or
Illustrate the steps involved in creating Synonyms
with an example.
15. How do you create the implicit cursor in SQL?
Explain with an example.
Or
Write the features of PL/SQL.
Part C 10 30)
Answer any three questions.
16. Briefly explain the transaction management.
17. Discuss the 4NF with an example.
AFC-10384
3
WS3
18. Give a brief account on parallel databases.
19. Briefly explain the concepts of Data Integrity.
20. Write a PL/SQL program to find the biggest one from
given n numbers using functions.
————————