Database Management Systems - Dec 2012

Information Technology (Semester 3)

TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks. 1(a) What is the purpose of a database?(5 marks) 1(b) Give difference between:(i) List box and Combo box(ii) Radio Button and Check Box(5 marks) 1(c) Explain views in SQL(5 marks) 1(d) What do you mean by Object linking and embedding?(5 marks) 2(a) Explain the terms:
(i) Entity
(ii) Cardinality
(iii) Weak Relationship
(iv) Composite Attribute
(v) Recursive Relationship
(10 marks) 2(b) Given the following business rules, create the appropriate ER Diagram:
(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 dependents.
(iv) Each employee might or might not have an employment history.(10 marks) 3(a) Discuss DDL and DML with examples(10 marks) 3(b) Use the small database shown in tables below to illustrate the natural join, and equijoin and an outer join.
(10 marks) 4(a) What do you mean by lock granularity? Explain two-phase locking protocol with an example.(10 marks) 4(b) Explain with an example how a deadlock condition is created? List the basic techniques to control deadlocks.(10 marks) 5(a) Explain the statement:"A transaction is a logical unit of work."(10 marks) 5(b) Write a note on transaction support provided by SQL.(10 marks) 6(a) Discuss database recovery management.(10 marks) 6(b) Explain how to convert an ER-scheme to relational tables with an example.(10 marks)

Write short notes on (any four):-

7(a) COM-DCOM (5 marks) 7(b) Client/Server Programming(5 marks) 7(c) ActiveX controls on the web(5 marks) 7(d) GUI Features(5 marks) 7(e) Database Administrator. (5 marks)