Anna University Chennai 2007-5th Sem B.E Computer Science and Engineering /B.Tech / 2008 CS1301 -DATABASE MANAGEMENT SYSTEMS (Regulation 2004) Time: 3 hours - Question Paper

DATABASE MANAGEMENT SYSTEMS MAY2007 - B.E CSE

PART-A

1. List 5 reponsibilities of the DB manager.
2. provide the limitations of ER model? How do you overcome this?
3. describe query language.Give the calssification of query language.
4. Why it is necessary to decompose a relation?
5. provide any 2 advantages of spare index over dense dense index.
6. Name the various kinds of joins supported in SQL.
7. elaborate the kinds of transperencies that a distributed database must support? why?
8. What benefit is given by strict-two phase locking? elaborate the disanvantages result?
9. Briefly write the overall process of dataware housing.
10. What is an active database?

PART - B
11 (a) (i) elaborate the kinds of knowledge discovered during data mining? discuss with suitable examples.
(ii) HIghlight the features of object oriented database.

OR
(b) (i) What is nested relationls? provide example.
(ii) discuss the structure of XML with suitable example.


12 (a) (i) Compare file system with database system.
(ii) discuss the architecture of DBMS.

OR
(b) (i) elaborate the steps involved in designing a database application? discuss with an example
(ii) List the possible kinds of relations that may exist ranging from 2 entities. How would you realise that into tables for a binary relation?

13. (a) (i) elaborate the relational algebra operations supported in SQL? Write the SQL statement for every operation.
(ii) Justify the need of normalization with examples
OR
(b) (i) What is normalization? discuss 1NF,2NF,3NF and BCNF with suitable example.
(ii) What is FD? discuss the role of Fd in the process of normalization.

14.(a) (i) discuss the security features given in commercial query languages.
(ii) elaborate the steps involved in query processing? How would you estimate the cost of the query?
OR
(b) (i) discuss the various properities of indexes in detail.
(ii) discuss different hashing techniques.

15.(a) (i) discuss the 4 important properities of transaction that a DBMS must ensure to maintain database .
(ii) What is RAID? List the various levels in RAID technology and discuss its features.
OR
(b) (i) What is concurrenct control? How is it implemented in DBMS? discuss.
(ii) discuss different recovery techniques during ttansaction in detail.

Earning:   Approval pending.