GUI & Database Management (S.E. Semester III) December 2012

GUI & Database Management (S.E. Semester III)  (3 Hours) 15 Nov Dec 2012
KR-3551 [Total Marks : 100]
N.B.	(1) Question No. 1 is compulsory. (2) Solve any four questions out of remaining six questions.
1.	(a) What is the purpose of a database system?	20
	(b) Give different between :-       (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:-      (i) Entity      (ii) Cardinality      (iii) Weak Relationship      (iv) Composite attribute      (v) Recursive relationship	10
	(b) Given the following business rules, create the appropriator ER diagrams :      (i) A company operators many departments      (ii) Each department employs one or more employees.      (iii) Each of the employees might or might not have one or more dependents.      (iv) Each employee might or might not have an employment history.	10
3.	(a) Discuss DDL and DML with examples.	10
	(b) Use the small database shown in fig1. to illustrate the natural join, and equijoin  and an outer join.	10
4.	(a) What do you mean by lock granularity? Explain two-phase locking protocol with an example.	10
	(b) Explain with an example how a deadlock condition is created? List the basic techniques to control deadlock.	10
5.	(a) Explain the statement :      " A transaction is a logical unit of work."	10
	(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) Client/server programming (c) Activex controls on the web (d) GUI features (e) Database Administrator.

Also see GUI & database management question papers May 2013