DATABASE MANAGEMENT SYSTEMS (Information Technology) Max. Marks: 70 Answer any FIVE questions All questions carry equal marks ---
With the help of diagram discuss the structure and components of a DBMS.
2.a) b)
Bring out few advantages and disadvantages of DBMS. What are the problems caused by data reduneries? Can explain whether data reduenaries be completely eliminated or not?
3.a) b)
Discuss the classification of different data models. Define the following terms: (i) Strong and Weak entities. (ii) E-R diagrams (iii) QBE.
4.
Consider a file of 10 million records with each record of 100 bytes long of which 5 bytes are the key field a physical block is 10 kilobytes and block addresses are 5 bytes long. If we use a B+ tree of order 500, how many index blocks are needed? What is the height of the tree? How many disk access are required to find a record?
5.
Convert the following tuple calculus query: t / t e rel1 s(s rel 2 ( s, c t.b)) Given the relations rel1 (A, B) and rel2 (C, D). into (i) English statement (ii) Domain calculus
uW
or ld
1.
(iii) Algebra.
Explain the following: Normalization using Join-dependencies. Multi—valued dependencies. 3NF, 4NF, BCNF.
7.
Write short notes on: (a) Query processing (b) Insertion and deletion in B+ trees (c) Buffer management.
Aj
nt
6. a) b) c)
8.a)
b)
How can a recovery system deal with recovery of Interactive transaction an online system such as Banking transaction system? In an adaptive deadlock detection scheme explain why it is necessary to choose an upper and lower limit for the frequency of running the dead lock algorithm. *** *** ***
With the help of diagram discuss the structure and components of a DBMS. 2.a) Bring out few advantages and disadvantages of DBMS. b) What are the problems caused by data reduneries? Can explain whether data · reduenaries be completely eliminated or not? 3.a) Discuss the classification of different data models.
6.a) List three basic requirements for a good rolling lubricant. b) A 300 mm wide aluminum alloy strip is hot-rolled in thickness from 20mm to · 15mm. The rolls ...
[8+8] · 2. (a) Describe the concept of automation in Machine Tools with examples. ... [8+8] · 5. (a) Describe the design and fabrication of automated flow lines.
(iii) Peak discharge using Snyder's equation for an unit hydrograph of 6 hour duration. Assume Ct=1.2, Cp=5, L=82 km, Lca=48 km with usual notations. [8+8].
6.a) Discuss the relative requirements of foundry furnaces suitable for melting Alluminium · and Copper alloys. b) Why is not the cupola furnace used for melting ...
sender and receiver side. The protocol we check appears both in a .... The action is a sequence of statements, exe- cuted when the condition holds. in addition, ...
Q1. a). Define Intra abdominal compartment syndrome. b). Explain its etiology and pathophysiology. c). Describe its nursing management. 2+3+5=15. Q2 a). Define Open Heart Surgery. b). Classify Open Heart Surgeries. c). Discuss Nursing Care plan of pa
b) State the characteristics of an ideal crusher. c) Discuss the characteristics of comminuted particles. [4+4+8] · 4.a) Write about the construction and working of a ...
We will explore rationing and will try to recreate living conditions of the time. we will also be reading a book about two children who travelled back in time to save ...
Page 3 of 14. Whoops! There was a problem loading this page. Retrying... Code Announcement.pdf. Code Announcement.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying Code Announcement.pdf. Page 1 of 14.
b) Write in detail the classical theory of diamagnetism. [8+8] · 5.a) Explain Fermi-Dirac distribution for electrons in a metal. Discuss its variation · with temperature.