Answer the following questions.
Question 1) What do you mean by Database Model? Describe, in brief the advantages of relational model.
Question 2) What are the different integrity constraints supported by Oracle server?
Question 3) Compare and contrast the terms: Relational algebra and Relational Calculus.
Question 4) What is Normalization and its need. Explain the Anomalies in 3NF relations?
Question 5)(a) what is a stored procedure? why do we require them? How are they different from functions and triggers?
(b) Explain the terms: Cursor and package in the context of SQL server.
Question 6) Distinguish between the following:
(a) Sub queries and correlated queries.
(b) Security and Integrity.
(c) Partial and Transitive Dependency.
(d) SQL and Oracle Server.
Question 7) Write brief notes on the following:
(a) Transact-SQl PLUS.
(b) Data base Recovery techniques.