Database Management Systems : Question Paper May 2013 - Information Technology (Semester 3)

4views

written 8.1 years ago by

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

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)

ADD COMMENT EDIT