Database Management Systems - May 2013
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 role of a DBMS, and what are its advantages?(10 marks) 1 (b) Explain in detail in built control and Active-x control in VB.(10 marks) 2 (a) Explain the following terms with examples :-
(i) an entity
(ii) a weak relationship
(iii) a strong relationship
(iv) a recursive relationship. (10 marks) 2 (b) Use the small database shown in figure(1) and answer the question :-
(i) Identify the primary keys
(ii) Identify the foreign keys
(iii) Create the Entity Relationship Model(ERM)
(iv) Create the relational database.
Table Name : Student
Table name : Subject
|301 IT Th||DBMS||12|
|302 IT Th||OOPS||11|
|303 IT Th||AT||12|
|304 IT Th||M-III||10|
|305 IT Pr||DBMS||11|
|306 IT Pr||OOPS||12|
|307 IT Pr||AT||11|
Figure 1 small database :(10 marks) 3 (a) Describe two-phase locking protocols and graph based protocols(10 marks) 3 (b) Explain the use of logs and check points for recovery in a database.(10 marks) 4 (a) Explain the terms ODBC and OLEDB.(10 marks) 4 (b) What are the features of GUI? Explain dicision making statement and loop structures statement in VB.(10 marks) 5 (a) What do you mean by deadlocks in database system? Explain the techniques for deadlocks prevention and deadlock detection.(10 marks) 5 (b) Why transaction processing system usually allow concurrent executions? Give reasons.(10 marks) 6 (a) What do you mean by a virtual table or a view. What are its characteristics?(10 marks) 6 (b) Write a notes on relational algebra.(10 marks)
Write short notes on (any four):-
7 (a) ACID properties(5 marks) 7 (b) OODBMS and ORDBMS(5 marks) 7 (c) DBA(5 marks) 7 (d) Murphy's law of GUI design(5 marks) 7 (e) EER model.(5 marks)