Mumbai University, B.E in Computer Science, 4th Sem., Database Management previous ye

Hii sir, I am the student of th BE 4th Sem my examinations are near please provide me the previous year question paper of the Database Management subject ?

[sumit]

As you asking for the previous year question paper of the B.E in Computer Science, 4th Sem., Database Management the question paper is given below :
a)HowmanyCodd'sRulesMustaDBMS satisfyto qualifyfor RDBMS?
(b) Whatis shadowPaging? .
(c) Whatarethe desirableproperties ofdecomposition.
(d) Listfour significant differences between file processing system and DatabaseManagementSystem
2. (a)Discussdifferentsecurityandauthorizationmechani sminDatabaseManagementSystem. 10
(b) Whatisdeadlock? What are the conditions necessary fordeadlock? Discussvarious strategies used for handling dead locks.

3.a) What are triggers? Give an example. Illustrate the cases when triggers must not be used. 10

(b) Explainthe following RelationalAlgebraicoperationswithexamples:- 10
(i) GeneralizedProjectron
(ii) SetIntersection
(iii) Aggregate
(iv) NaturalJoin
(v) Assignment.
5. (a)WhatdoyoumeanbyAuthorizationandAuthenticationsi n DBMS? Explainhowit 10
is implemented in SQLwithsuitableexample.
(b) What do you understand by concurrence control? Explain view serializability and Conflict serializability?
a) Whatis the importance ofnormalization in database design? Explain 1NF,2NF..3NF, 10
BCNF and 4NF giving examples.
(b) Answer the following questions:-(i) Explain the term super key,primary key,candidate key giving suitable example.
(ii) What are the different database users?
(iii) What is attribute? What are the different types of attribute? How they are represented in E-Rdiagram? .
7. Writeshortnoteson(anyfour):-(a) Datadictionary storages
(b) Timestamporderingprotocol
(c) Assertion
(d) B+Tree
(e) DatabaseAdministrator.