Amity University 2008-5th Sem B.Tech Biotechnology END TERM - Question Paper

BTBBT-30504
BACHELOR OF TECHNOLOGY(BIOTECHNOLOGY)

5th SEMESTER END TERM exam
DECEMBER 2008

DATABASE MANAGMENT SYSTEMS


TIME-3HRS MAXIMUM MARKS - 60


SECTION-A (24 marks)

attempt any four out of five every ques. carries six marks

1) elaborate the various traditional data models? discuss any two

2) what is normalization? discuss with suitable examples. also write the difference ranging from 2NF AND 3NF.

3)what are the various characteristics of data warehouse? explaim.

4)what are teh differnt database recovery techniques? discuss any two.

5)what is the data fragmentation technique? discuss with examples.


SECTION-B (20 marks)

attempt any 2 every ques. carries 10 marks

6) a) what is a deadlock? elaborate the various deadlock prevention tools? discuss.

b) elaborate various steps involved in data mining? discuss

7) elaborate the various concurrency control techniques? discuss.

8) elaborate the various views to design a data warehouse? discuss. also discuss the 3 tier architechture of data warehousing?


SECTION-C (16 marks)
compulsory

8 describe aggregation, specialization, data independence and metadata with suitable examples..

Earning:   Approval pending.