Question1) Answer all the questions.
(i) What are the management functions of DBMS?
(ii) Write brief note on Aggregation.
(iii) What are integrity rules?
(iv) What are anomalies in the database?
(v) What do you understand by relational algebra?
Question2) Describe purpose of database system in detail.
Question3) What is generalization? Describe with example.
Question4) Distinguish natural join and cross join with the help of suitable example.
Question5) Answer all the questions.
(i) Explain tuple variable and domain variable?
(ii) How a primary key is different from foreign key?
(iii) Why DBA is important to an enterprise?
(iv) Write down the advantages of ‘Centralized Database System’?
(v) What is DCL? What commands contains by DCL? Give names.
Question6) Describe DSN in detail.
Question7) Describe the operators set with meaning and use of all the operators with reference to tuple relational calculus.
Question8) What is the need of indexing? Describe various kinds of indexing techniques.