GUI & Data Base Management SE /IT/Sem III (December 2009)

GUI & Data Base Management SE /IT/Sem III (3 Hours)  (December 2009)
SP - 7439 [Total Marks : 100]
N.B.:	(1)	Questions no. 1 is compulsory.
	(2)	Solve any 4 questions from questions number 2 to 7.
	(3)	Assume appropriate data where necessary.
	(4)	All questions carry equal marks.
1.	(a)	Explain Database architecture in detail.	12
	(b)	Explain Murphy's low of GUI Design and standard of GUI.	08
2.	(a)	Consider the follwoing database, give an expression in SQL, Employee (employee-name, street, city, date of join) Works(employee-name, Company-name, salary) Comapny (comapny-name, city) Manages (employee-name, manager-name), 1] Find all employees in database who live in the same cities and on the same street as do their manager. 2] Find all employees who earn more than average salary of all employee of their company 3] Give all employees of XYZ      a 10% raise. 4] Find all employees who join in the month of march 5] Delete the smith belonging to XYZ company.	12
	(b)	Explain following relational algebra operator in detail,	08
3.	(a)	Explain time stamp ordering protocol and Thomas write rule in detail.	10
	(b)	Expalin shadow page recovery mechanism in DBMS.	10
4.	(a)	What is dead lock? How it is detected? Discuss different types of dead lock avoidance scheme.	10
	(b)	Draw the ER diagram for the university database, and convert it into relational database	10
5.	(a)	Answer the following, Give use of msgbox, input box with example State and explain use of OLE Significance of option Explicit Difference between List box and combo box Use of MDI form	10
	(b)	Explain ACID properties of transaction and state diagram.	10
6.	(a)	What is DBA? Explain it's function in detail.	10
	(b)	Define serializability? Explain conflict and view serializability	10
7.	Write notes on any four, 1) Validation based protocol 2) Checkpoint recovery mechanism 3) Weak entity set and strong entity set 4) Mapping constraints 5) Total participation, partial participation, Unique key, primary key, and partial key.		20

Also see GUI & database management question papers May 2010