Mumbai University Previous year question papers GUI and Database Management Dec 2012

Mumbai University Previous year question papers

III Sem IT Examination Dec 2012

GUI & Database Management

N.H.: (1) Question No.1 is compulsory.

(2) Solve any four questions out of remaining six questions.

 

l. (a) What is the purpose of a database system? 20

(b) Give difference hetween :-

(i) . Listbox and combobox

(ii) Radio button and check button.

(c) Explain views in SQL.

 (d) What do you mean by object linking and embedding?

  

2.(a) Explain the terms :- 10

(i) Entity

 (ii) CardinalitY

(Hi) Weak relationship

 (iv) ComposIte attribute

 (v) Recursive relationship.

 (b) Given the following business rules, creilte the appropriate ER diagram: 10

 (i) A company operates many departments

(ii) Each department employs one or more employees.

(Hi) Each of the employees might or might not have one or more depandents.

(iv) Each employee might or might not have

 an employment history.

 

3.(a) Discuss DDL and DML with examples. 10

(b) Use the small database shown in

 figl.

to illustrate. the natural join, and equijoin and im outer join.

 Table name: Student

 Stud

 

code Stud_name Subject Prof_code

 Ashish as 30

2 Rahul DBMS 10

3 Sourabh GAP 20

4 Nitesh DWM 10

5 Rajendra IP 50

6 Pratik:MEIT 30

ProCcode Prof name Phone

 10 Savita 96191

20 Smita 98690

30 Bhavna 99543

40 Uttara 78692

70 Kectti -82240

 

4. (a) What do you mean by lock granularity? Explain two-phase locking protocol with an example.

(b) -Explain with an example ho~ a deadlock condition is created? List the basic _techniques to control deadlocks.

 

5. (a) Explain the statement: 10

“A transaction is a logical unit of work.”

(b) Write a note on transaction support provided by SQL: 10

 

6. (a) Discuss database recover management. • 10

(b) Explain how to convert an ER-scheme to relational tables with an example. 10

 

7. Write short notes on (any four) :- 20

(a) COM-DCOM

(b) ClientI server programming

(c) Activex controls on the web

(d) GVI features

(e) Database Administrator

Leave a Comment