problem 1:

Discuss and describe the classification of DBMS based upon location of database.

problem 2:

Illustrate with illustrations different SQL commands employed for creating and deleting relations. prepare down a brief note on ACID properties of transaction model.

problem 3:

Illustrate out the term functional dependency. Provide exs. Also describe 1st, 2nd and 3rd normal Forms.

problem 4:

Illustrate the different heuristics which are involved in query optimization. Also illustrate the different algorithms for executing query operations.

problem 5:

Illustrate the most significant classes of parallel machines.

problem 6:

How is two (2) phases locking method employed to ensure serializability? Discuss.