15

16

17

18

19
20

C7415

Module 1V

a) What is a functional dependency? What are the possible sources of the (3) information
that defines the functional dependencies that hold among the attributes of a relation
schema?

b) Differentiate between Boyce- Codd Normal Form

and3NF. (3) 0२
Define first, second, and third normal forms when only primary keys (6) areconsidered.
How do the general definitions of 2NF and 3NF, which considerall keys of a relation, differ
from those that consider only primary keys?

Module V
a) Discuss the need of concurrency control with informal examples. (3) b)
Compare between Binary locks and Read/Write locks. (3) OR
Discuss the Problems of dead lock and starvation and the different approaches to (6) deal
with the problem.

Module VI
Explain in detail about frequent pattern tree algorithm. (6) OR
Discuss in detail the data modelling used for data ware house. (6)

പി

Page 2 of 2