M.Com. DEGREE EXAMINATION,
NOVEMBER 2017
Second Semester
Commerce with Computer Applications
Elective — DATA BASE MANAGEMENT SYSTEM
(CBCS 2015 onwards)
Time 3 Hours Maximum 75 Marks
Section A (10 x 2 20)
Answer all questions.
1. Write a short note on Database System Applications.
2. What are the components of storage manager?
3. What is the basic structure of relational model?
4. Write a note on the tuple relational calculus.
5. Define Fourth normal form.
6. Give an example for SQL queries.
7. What is meant by transaction state?
8. What do you mean by granting of locks?
9. Write a note on hash based indexing.
10. What do you mean by cluster Indexes?
Sub. Code
5MCC2E1
AFF-5091
2
Ws5
Section B x 5 25)
Answer all questions.
11. State the various data models.
Or
Explain the database design with ER diagram.
12. Explain Selection, Projection, Renaming,
Joins and division with examples.
Or
Explain safety of expressions.
13. What is meant by triggers? Explain its needs with
some example queries.
Or
Explain about Multi valued Dependencies.
14. Explain about recovery algorithm with features.
Or
Explain an operating system role in buffer
management.
15. Discuss about dynamic index structure.
Or
Explain Tree base indexing with example.
AFF-5091
3
Ws5
Section C 10 30)
Answer any three questions.
16. Briefly explain the entity relationship model with
diagrams.
17. Discuss the extended relational algebra operations.
18. Briefly explain about BCNF with example.
19. Explain about remote backup systems.
20. Explain Indexing and Indexed Sequential Access
Methods (ISAM).
————————