B.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Fifth Semester
Information Technology
DATABASE MANAGEMENT SYSTEMS
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. Name any two database languages.
2. Define Entity.
3. Give an example for functional dependency.
4. What is Normalisation.
5. Define Parallel system.
6. What is meant by distributed database?
7. Define Schema.
8. How to define a table?
9. Give the expansion for PL/SQL.
10. What is a Cursor?
Sub. Code
4BIT5C1
AFF-4548
2
Ws15
Part B x 5 25)
Answer all questions by choosing either or
11. Mention the purpose of database system.
Or
What are the issues that arise in E-R design?
12. List the salient features of good relational design.
Or
How decomposition can be done by using
multivalued dependencies?
13. How to achieve I/O parallelism?
Or
How homogeneous database differs from a
heterogeneous database?
14. How to achieve data integrity?
Or
Give the importance of Indexing.
15. How to iniate the Triggers?
Or
Explain the concept of packages in PL/SQL.
AFF-4548
3
Ws15
Part C 10 30)
Answer any three questions.
16. What are the blocks used in E-R diagrams? Explain the
concept with an example.
17. Discuss on the First Normal Form.
18. How interquery parallelism differs from Intraquery
parallelism?
19. Explain the technique of creating tables.
20. Discuss the usage of functions in PL/SQL.
————————