problem1) Answer all the problems.
(i) What are the management functions of DBMS?
(ii) prepare brief note on Aggregation.
(iii) What are integrity rules?
(iv) What are anomalies in the database?
(v) What do you understand by relational algebra?
problem2) Describe purpose of database system in detail.
problem3) What is generalization? Describe with ex.
problem4) Distinguish natural join and cross join with the help of suitable ex.
problem5) Answer all the problems.
(i) describe tuple variable and domain variable?
(ii) How a primary key is different from foreign key?
(iii) Why DBA is important to an enterprise?
(iv) prepare down the advantages of ‘Centralized Database System’?
(v) What is DCL? What commands contains by DCL? Give names.
problem6) Describe DSN in detail.
problem7) Describe the operators set with meaning and use of all the operators with reference to tuple relational calculus.
problem8) What is the need of indexing? Describe various kinds of indexing techniques.