B.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Fifth Semester
Software
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. Define Data Mining.
3. What is functional dependency?
4. What is meant by Lossless Decomposition?
5. Define Data Servers.
6. Write about distributed database system.
7. List out the possible user privileges.
8. Define schema.
9. Differentiate procedure and function.
10. Define package.
Sub. Code
4BSOE2A
AFF-4580
2
WS3
Part B x 5 25)
Answer all questions, choosing either or
11. Write short notes on Data Definition Language.
Or
Explain Mapping Cardinalities.
12. Discuss about keys and functional dependencies.
Or
Explain the features of good Relational Designs.
13. Differentiate centralized and client sever
Architecture.
Or
Discuss about distributed systems with example.
14. What are views? Explain with examples.
Or
Write short notes on integrity constraints.
15. Discuss about PL/SQL Block with an example.
Or
What is Trigger? Explain with an example.
Part C x 10 30)
Answer any three questions.
16. Discuss about the major components of Entity
Relationship diagram with an example.
17. Explain Third and Boyce Codd normal form.
AFF-4580
3
WS3
18. Write in detail about the parallel Database Architectures.
19. How do you create a student table and perform table
management?
20. What are the four operations that must be performed for
successful working of cursor? Explain.
————————