Calicut University 2008-3rd Sem M.C.A ,ch/il - Question Paper

3rd semester MCA degree examination,march/april ,2008
MCA 2k 303 -Database Management Systems
Time: 3 hour Maximum :100 marks
ans any 5 ques.
1. a) describe Data base and Data base systems. elaborate the advantages of using DBMS ? [10 marks]
b) What is mean by local data,indepandence and physical data independence ? [10 marks]

2. a) provide the concept of parallelising data access using RAID technology. [10 marks]
b) In what situation ,we go for secondary index structure ? discuss secondery indexing in details .How do indexing make search process faster. [10 marks]

3. a)Explain join dependencies and 5th normal form. [10 marks]
b) discuss the subsequent relational algebraic operations :-
1. Division
2. Join
3. Cartesian product
4. Set difference
5. Project [10 marks]

4. a) Difference ranging from view serializability and conflict serializability. [10 marks]
b) What is mean by granularity of data items ? How do granularity affect the locking algorithms. [10 marks]

5. a) discuss the subsequent terms with respect to ER model:-
1. Weak entity kinds.
2. Total and partial participation .
4. Multivalued attributes.
5. Recursive relationships [12 marks]
b) What is meant by specialisation /generalisation hierarchies and lattices. [8 marks]

6. a) Compare single level indexes with multilevel indexes. [10 marks]
b) Draw the node structure for B and B+ trees are more preferred access structure than B- trees [10 marks]

Earning:   Approval pending.