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

GUI & Data Base Management SE /IT/Sem III (3 Hours)  18/12/2010
GT - 6312 [Total Marks : 100]
N.B.:	(1)	Questions no. 1 is compulsory.
	(2)	Answers any four out of the remaining questions.
1.	(a)	Write advantages of DBMS over a file system.	05
	(b)	Explain Murphy's law of GUI Design with the help of an example.	05
	(c)	What is a view? How is it created and stored?	04
	(d)	Explain the following controls of visual basic: (i) Listbox (ii) Combobox (iii) Checkbox.	06
2.	(a)	Explain following relationship algebra operators with suitable examples : (i) Select (ii) Project (iii) Join (iv) Division (v) Cartesion product	10
	(b)	What is transaction? Discuss state transaction diagram and properties of transaction.	10
3.	(a)	Elaborate design consideration of GUI.	10
	(b)	Discuss option Explicit Statement with example.	10
4.	(a)	What do you understand by deadlocks in database system? Explain how is it prevented.	10
	(b)	Explain any one timestamp based protocol.	10
5.	(a)	For the given employee database give an expression in SQL for the following :      Employee (empname, street, city)      Works (empname, company-name, salary)      Company (company-name, city)      Manages (empname, manager-name) (i) Modify the database so that 'Shiv' now lives in 'Mumbai' (ii) Give all employees of satyam a 50 percent raise. (iii) List all the employees who lives in the same cities as their managers.	10
	(b)	Define serializability? Explain conflict and view serializability.	10
6.	(a)	Explain rules for converting ER model to relational model.	10
	(b)	Construct ER diagram for a bank (state the assumptions clearly). convert this ER diagram into tables.	10
7.	Write short notes on :- (i)     Weak entity set, Specialization, Generalization (ii)     Total participation, Partial participation, unique key, primery key and partial key (iii)     Logbased and checkpoint based recovery mechanisms.		07 06 07

Also see GUI & database management question papers December 2012