B.Sc. DEGREE EXAMINATION, APRIL 2018
Fifth Semester
Information Technology
DATABASE MANAGEMENT SYSTEMS
(CBCS 2011 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all the 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. What is Stored procedure?
10. State the uses of Packages.
Sub. Code
1BIT5C1
AFC-10693
2
Wk7
Part B x 5 25)
Answer all the 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 salient features of PL/SQL.
AFC-10693
3
Wk7
Part C x 10 30)
Answer any three questions.
16. Briefly explain the transaction management.
17. Discuss the 4NF with an example.
18. Give a brief account on parallel databases.
19. Briefly explain the concepts of Data Integrity.
20. Write PL/SQL program to find smallest of three numbers.
————————