Mumbai University IT II Year III Semester GUI and Database Management Question Papers
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?
(a) Explain the terms :- 10
(iii) 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.
(iii) Each of the employees might or might not have one or more depandents.
(iv) Each employee might or might not have an employment history.
(a) Discuss DDL and DML with examples. 10
(b) Use the small database shown in figl. to illustrate. the natural join, and equijoin 10 and im outer join.
Table name: Student Stud code Stud_name Subject Prof_code
1. 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 9619120 Smita 98690 30 Bhavna 9954340 Uttara 7869270 Kectti -82240
4. (a) What do you mean by lock granularity? Explain two-phase locking protocol with 10 an example.
(b) -Explain with an example ho~ a deadlock condition is created? List the basic 10 _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
I server programming
(c) Activex controls on the web
(d) GVI features
_(e) Database Administrator.