Shivaji University 2006 B.E Computer Science DATABASE ENGINEERING - Question Paper
Sunday, 19 May 2013 10:20Web
H-357
THIRD YEAR OF COMPUTER SCIENCE AND ENGINEERING (PART-2) EXAMINATION, 2006
SHIVAJI UNIVERSITY, KOLHAPUR
DATABASE ENGINEERING
Day and Date: Thursday, 22-05-2006 Total Marks: 100
Time: 10.00p.m. To 1.00p.m.
Instructions:
Instructions:
1) Solve any 3 ques. from SECTION-1
2) Solve any 3 ques. from SECTION-2
3) Figures to right shows full marks
SECTION-1
Q.1
a) Distinguish Database System And File System. [Marks 8]
b) define ER model. [Marks 8]
Q.2.
a) List and discuss the fundamental operations on relational algebra. [Marks 8]
b) What is key? discuss various keys in relational model. [Marks 8]
Q.3
a) Explain file organization wit variable length records. [Marks 8]
b) What is data dictionary storage? Illustrate with example. [Marks 8]
Q.4 Write a short notes on (any three): [Marks 18]
a) Reducing ER diagram to tables
b) Domain relational calculus
c) Normalization using functional dependencies
d) Sequential file organization
SECTION-2
Q. 6)
a) List and explain storage kinds and failure kinds. [Marks 8]
b) discuss immediate database modification recovery scheme with example.[Marks 8]
Q.6)
a) Explain 2 phase looking protocol with example.. [Marks 8]
b) elaborate methods or lock used in multiple granularity schemes? provide compatibility matrix for them. [Marks 8]
Q.7)
a) Explain the stable storage implementation in detail [Marks 8]
b) Explain activity level analysis using SPC. [Marks 8]
Q.8) Write a short notes on (any three): [Marks 18]
a) Estimation of query processing cost
b) Testing for serializability
c) Buffer management
d) Multiple key access
Earning: Approval pending. |