Discuss and describe the classification of DBMS based upon location of database.
Illustrate with illustrations different SQL commands employed for creating and deleting relations. prepare down a brief note on ACID properties of transaction model.
Illustrate out the term functional dependency. Provide exs. Also describe 1st, 2nd and 3rd normal Forms.
Illustrate the different heuristics which are involved in query optimization. Also illustrate the different algorithms for executing query operations.
Illustrate the most significant classes of parallel machines.
How is two (2) phases locking method employed to ensure serializability? Discuss.