Question Paper: Database Management Systems : Question Paper May 2013 - Information Technology (Semester 3) | Mumbai University (MU)

Database Management Systems - May 2013

Information Technology (Semester 3)

(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

Stud_no Stud_name Stud_DOB
10 Bhuvi 15-8-90
11 Dhriti 26-1-92
12 Shree 5-9-95

Table name : Subject
Sub_code sub_name stud_no
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)

Please log in to add an answer.