M.Com. (C.A.) DEGREE EXAMINATION, APRIL 2018
Second Semester
Commerce with Computer Application
Elective — DATA BASE MANAGEMENT SYSTEM
(CBCS 2017 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is meant by Database?
2. Explain about DBMS.
3. What is ER Model?
4. Write the entities and attributes with example.
5. What is relational algebra and why is it important?
6. What subset of mathematical logic is used in relational
calculus?
7. What is functional dependencies?
8. What are Normal forms and what is their purpose?
9. How does a DBMS store and access persistent data?
10. What is an Index and why is it used?
Sub. Code
7MCC2E1
AFS-0535
2
Wk3
Part B x 5 25)
Answer all questions choosing either or
11. Write short notes on overview of Database systems.
Or
Discuss the managing data in Database systems.
12. Define these terms
entity
entity set
attribute
key.
Or
Explain about the weak entities.
13. Explain about the set operations with neat
diagrams.
Or
Discuss the selection and projection to the relational
algebra.
14. Define the BCNF with suitable example.
Or
Explain about the decomposition.
15. How does a hash based index work and when is it
most effective?
Or
Explain briefly tree based index work.
AFS-0535
3
Wk3
Part C x 10 30)
Answer any three questions.
16. Explain
advantages of DBMS and
other data models.
17. Explain briefly database design and ER diagrams.
18. Explain selection and projection set operations.
19. Define ONE, TWO THREE Normal forms and BCNF.
Explain them.
20. Discuss the file organization and indexing.
————————