Pondicherry University 2009 B.Tech Computer Science and Engineering dergree , il/ , Database Management Systems - Question Paper

ans ALL THE QUESTIONS:

1.(a) elaborate the different disadvantages of storing organizational info in a file-processing system?(8)
(b) define the different data models of database. (7)

(or)

2. explain a few of the extended features of Entity-Relationship diagram. (15)

3. explain the different concepts underlying the relational data model of a banking enterprise. (15)

(or)

4. discuss the subsequent relational languages:
(a) QBE. (8)
(b) Datalog.(7)


5. Write short notes on the following:
(a) Referential Integrity. (7)
(b) Functional Dependencies. (8)

(or)

6. discuss the 2 normal forms for relational-database schemes and also compare it. (15)


7. discuss the magnetic disk storage device in detail. (15)

(or)

8. define in detail about B+- Tree index files. (15)

9.(a) discuss the 2 principal methods for dealing with the deadlock issue. (9)
(b) List and discuss the properties of the transactions that the database system maintain. (6)

(or)

10. explain the following:
(a) Shadow Paging. (8)
(b) Graph-based Protocol. (7)

Earning:   Approval pending.