Answer the following problems.
problem 1) What is Data base Model? describe in brief the advantages of relational model.
problem 2) What do you mean by Data independence and its need? How it is achieved in the RDBMS?
problem 3) What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
problem 4) prepare down the different operations supported by Relational algebra.
problem 5) What do you mean by stored procedure? How it is different from query? Can you instantiate a COM object by using T-SQL?
problem 6)(a) describe the terms: Attribute, Domain, Relation with the help of suitable ex.
b) Distinguish between the following:
(i) Public and Private packages.
(ii) Recovery and Backup.
problem 7) What is Normalization and its need? describe in brief the different steps used to normalize any data base.
problem 8) prepare brief notes on the following:
(a) Oracle Server.
(b) Data base Security.