MU Information Technology (Semester 3)
Database Management Systems
May 2013
Total marks: --
Total time: --
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary

1 (a) What is role of a DBMS, and what are its advantages?
10 M
1 (b) Explain in detail in built control and Active-x control in VB.
10 M

2 (a) Explain the following terms with examples :-
(i) an entity
(ii) a weak relationship
(iii) a strong relationship
(iv) a recursive relationship.
10 M
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 M

3 (a) Describe two-phase locking protocols and graph based protocols
10 M
3 (b) Explain the use of logs and check points for recovery in a database.
10 M

4 (a) Explain the terms ODBC and OLEDB.
10 M
4 (b) What are the features of GUI? Explain dicision making statement and loop structures statement in VB.
10 M

5 (a) What do you mean by deadlocks in database system? Explain the techniques for deadlocks prevention and deadlock detection.
10 M
5 (b) Why transaction processing system usually allow concurrent executions? Give reasons.
10 M

6 (a) What do you mean by a virtual table or a view. What are its characteristics?
10 M
6 (b) Write a notes on relational algebra.
10 M

Write short notes on (any four):-
7 (a) ACID properties
5 M
5 M
7 (c) DBA
5 M
7 (d) Murphy's law of GUI design
5 M
7 (e) EER model.
5 M

More question papers from Database Management Systems