Shivaji University 2006 B.E Computer Science DATABASE ENGINEERING - exam paper

H-357
THIRD YEAR OF COMPUTER SCIENCE AND ENGINEERING (PART-2) EXAMINATION, 2006
SHIVAJI UNIVERSITY, KOLHAPUR
DATABASE ENGINEERING

Day and Date: Wednesday, 22-11-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) Explain entities, their sets and mapping constraints. [Marks 8]

b) discuss the advantages of database systems over condensational file system. [Marks 8]

Q.2.
a) What do you understand by domain relational calculus? discuss with example. [Marks 8]

b) With example discuss normalization is using join dependencies. [Marks 8]


Q.3
a) What is meant by file organization? discuss at lowest three various file organizations. [Marks 8]

b) What is data dictionary storage? Illustrate with example. [Marks 8]

Q.4 Write a short notes on [Marks 18]

a) Generalization
b) Relational algebra
c) Attributes kinds in ER diagram











SECTION-2

Q. 6)
a) Comment on the difference ranging from index-sequential files and B+ tree file organization. [Marks 8]

b) define the steps in query processing along with necessary diagram.[Marks 8]



Q.6)
a) Classify the different kinds of failures that may occur in a system. [Marks 8]

b) What is view of serilizable? discuss the steps.. [Marks 8]

Q.7)

a) Explain static and dynamic hash function. [Marks 8]
b) Explain transaction in detail. [Marks 8]

Q.8) Write a short notes on (any three): [Marks 18]

a) Validation technique
b) Buffer management
c) Multiple key access

Earning:   Approval pending.