B.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Fifth Semester
Computer Science
Elective — DATABASE MANAGEMENT SYSTEM
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is Database Management System?
2. What do you mean by Meta data?
3. Define Determinant.
4. List out the Normal forms.
5. Define Inter query parallelism.
6. What is fragmentation?
7. What is the syntax of CREATE table command?
8. What is Index?
9. What is meant by Trigger?
10. What is Cursor?
Sub. Code
4BCEE2A
AFF-4566
2
Ws8
Part B 5 25)
Answer all questions, choosing either or
11. Discuss about Basic concept of ER model.
Or
Who is database administrator and explain its
functions?
12. Compare the 3NF and BCNF.
Or
Discuss about Database design process.
13. Explain the distributed systems.
Or
Differentiate the Homogeneous and Heterogeneous
database.
14. Explain how views are created using an example.
Or
Differentiate the Book Index and a Table index.
15. Write steps to create and execute a Trigger.
Or
Write notes on
Function
Procedure.
AFF-4566
3
Ws8
Part C x 10 30)
Answer any three questions.
16. Explain about overall logical structure of the database.
17. Discuss the pitfalls in relational database design.
18. Explain the client/server architecture of the distributed
databases with the help of a sketch.
19. Describe in detail about types of Indexes.
20. Write a PL/SQL program to do the Arithmetic operations
by using packages.