S.E. (IT) Semester III GUI & Database Management / IT (May 2013)

S.E. (IT) Semr III

GUI & Database Management / IT (May 2013)

Con. 6614-13

GS-6543

(3 Hours)

[Total Marks: 100]

N.B.: (1) Question No. 1 is compulsory.
(2) Attempt any four questions from remaining six questions.
1. (a) What is the role of DBMS, and what are its advantages? – (10 Marks)
(b) Explain in detail in built control and Active- X control in VB. – (10 Marks)
2. (a) Explain the following terms with example:- (10 Marks)

1. An entity
2. A weak relationship
3. A strong relationship
4. A recursive relationship

(b) Use the small database shown in figure (1) and answer the questions: - (10 Marks)

1. Identify the primary keys
2. Identify the foreign keys
3. Create the Entity Relationship Model (ERM)
4. 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	Figure1 small database
305 IT Pr	DBMS	11
306 IT Pr	OOPS	12
307 IT Pr	AT	11

3. (a) Describe two phase locking protocols and graph based protocols.—(10 Marks)
(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)
(b) What are the features of GUI ? Explain decision making statements and loop structures statement in VB. – (10 Marks)
5. (a) What do you mean deadlocks in database ? Explain the techniques for deadlock prevention and deadlock detection. –(10 marks)
(b) Why transaction processing systems 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)
(b) Write a note on relational algebra. – (10 Marks)
7. Write short notes on (any four):--- (10 Marks)

• ACID properties
• OODBMS and ORDBMS
• DBA
• Murphy’s law of GUI design
• EER Model

Also see GUI & database management question papers May 2009