Anna University Chennai 2007-5th Sem B.E Computer Science /B.TECH, /E (Regulation 2004) and Engineering CS1301 – DATABASE MANAGEMENT SYSTEMS - Question Paper

B.E/B.TECH.DEGREE EXAMINATION, MAY/JUNE 2007.
Fifth Semester
(Regulation 2004)
Computer Science and Engineering
CS1301 – DATABASE MANAGEMENT SYSTEMS
(Common to info Technology and B.E. Part – Time R 2005 4th Semester)
(Regulation 2004)
Time: 3 hours Maximum: 100 marks
ans ALL ques.
PART A – (10 ´ two = 20 marks)
1. List 5 responsibilities of the DB Manager.
2. provide the limitations of E – R model? How do you overcome this?
3. describe query language. provide the classification of query language.
4. Why it is necessary to decompose a relation?
5. provide any 2 advantages of sparse index over dense index.
6. Name the various kinds of joins supported in SWL.
7. elaborate the kinds of transparencies that a distributed database must support?
Why?
8. What benefit is given by strict – 2 phase locking? elaborate the
disadvantages results?
9. Briefly write the overall process of data warehousing
10. What is an active database?
PART B – (5 ´ 16 = 80 marks)
11. (a) (i) elaborate the kinds of knowledge discovered during data mining? discuss
with suitable examples. (8)
(ii) Highlight the features of object oriented database. (8)
Or
C3149
________________________________________________________________________
(b) (i) What is nested relations? provide example. (8)
(ii) discuss the structure of XML with suitable example. (8)
12. (a) (i) Compare file system with database system. (8)
(ii) discuss the architecture of DBMS. (8)
Or
(b) (i) elaborate the steps involved in designing a database application? discuss
with an application. (10)
(ii) List the possible kinds of relations that may exist ranging from 2 entities.
How would you realize that into tables for a binary relation? (6)
13. (a) (i) elaborate the relational algebra operations supported in SQL? Write the
SQL statement for every operation. (8)
(ii) Justify the need for normalization with examples. (8)
Or
(b) (i) What is normalization? discuss 1NF, 2NF, 3NF and BCNF with suitable
example. (8)
(ii) What is FD? discuss the role of FD in the process of normalization.(8)
14. (a) (i) discuss the security features given in commercial query languages.(8)
(ii) elaborate the steps involved in query processing? How would you estimate?
the cost of the query? (8)
(b) (i) discuss the various properties of indexes in detail. (8)
(ii) discuss different hashing techniques. (8)
15. (a) (i) discuss the 4 important properties of transaction that a DBMS must ensure
to maintain database. (8)
(ii) What is RAID? List the various levels in RAID technology and discuss its
features. (8)
Or
(b) (i) What is concurrency control? How is it implemented in DBMS? discuss. (8)
(ii) discuss different recovery techniques during transaction in detail. (8)

Earning:   Approval pending.