Different system management tools in a data warehouse

Question

Question 1)a) Briefly explain the following:                             

i)  Data Abstraction

ii) Object Identity

iii) Inheritance

iv) Polymorphism

v) Message passing

b) Write down the advantages and disadvantages of object oriented approach.  

Question 2) Describe the phases of database design process in detail.                     

Question 3)a) Explain Functional dependency in detail.                        

b) Describe INF, 2NF, 3NF, BCNF with relations                     

Question 4)a) Describe the steps for design of data warehouses.                     

b) With neat and well labelled diagram describe the architecture of data warehouses.   

Question 5)a) What do you mean by statistical databases?                           

b) Write a detailed notes on Meta data repository.                       

c) Describe data warehouse applications in detail.                     

Question 6)a) Explain about tuning the data warehouses.                        

b) Define

i) Data cube 

ii) Dimension table                   

c) Briefly explain capacity planning.                         

Question 7)a) Describe data warehouse process.

b) Describe the different system management tools in a data warehouse.

Question 8)a) Write a short notes on: 

i) BLOB & CLOB 

ii) Data archiving        

b) How testing is performed in data warehouses.