B.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Fifth Semester
Information Technology
DATABASE MANAGEMENT SYSTEMS
(CBCS 2011 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is a relational database?
2. Define entity.
3. What is normalization?
4. What is meant by functional dependency?
5. Define Parallel system.
6. Mention the name of the Network types.
7. Give the syntax for creating table.
8. What is meant by view?
9. What is a Cursor?
10. Define Trigger.
Sub. Code
1BIT5C1
AFC-10401
2
Wk 10
Part B x 5 25)
Answer all questions, choosing either or
11. What is an E-R diagram? Explain with an example.
Or
Explain briefly about Database System
Applications.
12. What is BCNF? Explain the difference between
BCNF and 3-Normal Form.
Or
Explain 1st and 2nd Normal Forms with example.
13. Explain about centralized computer system with
neat diagram.
Or
Distinguish homogenous and heterogeneous
distributed database.
14. Briefly discuss about sequence with suitable
example.
Or
Write short notes on user privileges and roles.
15. How can you create and execute a stored procedure?
Explain with an example.
Or
Explain cursor attributes with their syntax.
AFC-10401
3
Wk 10
Part C x 10 30)
Answer any three questions.
16. Explain the architecture of database system with neat
diagram.
17. Discuss on multivalued functional dependencies with
example.
18. Explain architecture of parallel database with neat
diagram.
19. Describe the uses of views.
20. Explain different types of database triggers with suitable
example.
———————