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
(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
to illustrate. the natural join, and equijoin and im outer join.
Table name: Student
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
(b) ClientI server programming
(c) Activex controls on the web
(d) GVI features
(e) Database Administrator