B.Sc. DEGREE EXAMINATION, APRIL 2018
Third Semester
Computer Science
DATABASE MANAGEMENT SYSTEMS
(CBCS 2011 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. Define DBMS.
2. Define strong and weak entity.
3. What is atomic domain?
4. Define BCNF.
5. What is meant by homogeneous database?
6. What are different types of network?
7. What is role?
8. What is synonym?
9. What is the difference between function and trigger?
10. What is explicit cursor?
Sub. Code
1BCE3C1
AFC-10680
2
Ws5
Part B x 5 25)
Answer all questions choosing either or
11. Explain different type of database users.
Or
Explain aggregation in E-R diagram with an
example.
12. Explain steps involved in database design process.
Or
Discuss steps involved in modeling temporal data.
13. Explain centralized database system architecture.
Or
Explain inter query parallelism.
14. Write short notes on data integrity.
Or
Explain insert, update and delete operations in
tables.
15. Explain stored procedure with an example.
Or
Explain function with an example.
AFC-10680
3
Ws5
Part C x 10 30)
Answer any three questions.
16. Explain purpose of database system.
17. Explain decomposition with multivalued dependency.
18. Write short notes heterogeneous databases and
distributed transactions.
19. Write short notes on index, sequence and views.
20. Explain about of cursor with an example.
————————