B. Tech III Year I Semester Examinations, December-2011 DATABASE MANAGEMENT SYSTEMS (ELECTRONICS AND COMPUTER ENGINEERING)
Time: 3 hours
Max. Marks: 75
.in
Answer any five questions All questions carry equal marks --1.a) b)
Compare the Database system and File system. Discuss briefly about Transaction Management, Storage management.
2.a)
What is meant by Mapping cardinalities? Discuss various Mapping cardinalities with suitable examples. Draw an ER-diagram corresponding to customers and loans and Explain various rotations used in it. [7+8]
or ld
b)
[7+8]
What is meant by Tuple relational calculus? State and explain various types of queries in it. And also compare it with Domain relational calculus. [15]
4.a) b)
Discuss about Outer Joins and disallowing NULL values in SQL. State and explain various comparison operators and aggregative operators in SQL. [7+8]
5.a)
What is meant by Schema refinement? Compare the first and second normal forms. Explain the Lossless join decomposition with a suitable example. [7+8]
b)
uW
3.
List the ACID properties. Explain the usefulness of each. Discuss about multiple granularity.
[7+8]
7.a) b)
Discuss the process of recovery with concurrent transactions. Explain about Remote backup systems.
[7+8]
8.
What is meant by File organization and indexing? Discuss about Hash- based indexing and Tree- based indexing. [15]
Aj
nt
6.a) b)
--ooOoo--
Code No: 09A51901
R09
SET-2
B. Tech III Year I Semester Examinations, December-2011 DATABASE MANAGEMENT SYSTEMS (ELECTRONICS AND COMPUTER ENGINEERING)
Time: 3 hours
Max. Marks: 75
.in
Answer any five questions All questions carry equal marks --1.a) b)
What are Data base languages? Explain them. With a neat diagram explain the data base system structure.
2.a)
What is meant by a Ternary relationship? Draw sample ER-diagrams with a Ternary relationship and with a weak entity set. Explain the distinctions among the terms primary key, candidate key, and super key. [7+8]
or ld
b)
[7+8]
Discuss various selection and projection set operations. What is meant by Domain relational calculus? State and explain various types of Queries in it. [7+8]
4.a) b)
Explain the basic structure of an SQL Query with a suitable example. What are the aggregate functions that SQL offers? Explain them with suitable examples. [7+8]
5.a)
What is meant by Normal form? Discuss about Third normal form with an example. What are Multi- valued dependencies? Discuss about normalization using multi valued dependencies. [7+8]
b)
uW
3.a) b)
Describe the concepts “Serializability” and “Recoverability”. What are Time stamp based protocols? Explain any one of them.
7.a) b)
What are the errors that may cause a transaction to fail? Explain them. Discuss in detail about Log – based recovery system. [7+8]
nt
6.a) b)
Explain the concept of Hash based indexing with a suitable example. Discuss about Indexed Sequential Access Methods.
Aj
8.a) b)
--ooOoo--
[7+8]
[7+8]
Code No: 09A51901
R09
SET-3
B. Tech III Year I Semester Examinations, December-2011 DATABASE MANAGEMENT SYSTEMS (ELECTRONICS AND COMPUTER ENGINEERING)
Time: 3 hours
Max. Marks: 75
.in
Answer any five questions All questions carry equal marks --What is meant by Data abstraction? Discuss about DDL and DML. Discuss various functions of the database administrator. And also discuss about various types of database users. [7+8]
2.
Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. And also construct appropriate table for this E-R diagram. [15]
3.
What is a Relational algebra? State and explain various fundamental operations in it with suitable examples. [15]
4.
State and explain with suitable examples the comparison operators, aggregate operators and NULL values in SQL. [15]
5.a) b)
State and explain fourth normal form with a suitable example. Compare BCNF and third normal form.
6.
What are lock based protocols? Explain them in detail.
[15]
7.a) b)
What is meant by atomicity? Discuss about Log – based recovery. Explain the concept of shadow paging with a suitable example.
[7+8]
8.a) b)
Describe the concept of primary and secondary indexes. Discuss about Tree -based indexing and Hash based indexing.
[7+8]
Aj
nt
uW
or ld
1.a) b)
--ooOoo--
[7+8]
Code No: 09A51901
R09
SET-4
B. Tech III Year I Semester Examinations, December-2011 DATABASE MANAGEMENT SYSTEMS (ELECTRONICS AND COMPUTER ENGINEERING)
Time: 3 hours
Max. Marks: 75
.in
Answer any five questions All questions carry equal marks --What is meant by a Data base system? Discuss its advantages over file system. Discuss about storage manager and query processor. [7+8]
2.a)
Discuss how ER diagrams are used in designing a data base. Discuss about various entity sets. What is meant by Relationship sets? Discuss about binary and n-ary relationship sets. [7+8]
b)
or ld
1.a) b)
Compare the Tuple relational calculus and the Domain relational calculus. What is meant by integrity constraints over relations? Give a suitable example. [7+8]
4.a) b)
What is meant by SQL? Explain about nested queries and NULL values in SQL. Discuss about complex integrity constraints is SQL. [7+8]
5.a) b)
State and explain with a suitable example the third normal form. Discuss the Pitfalls in Relational database design.
6.a)
What is meant by Transaction? Discuss about ACID properties of the transactions. Explain the distinction between the terms “serial schedule” and “Serializable schedule”. [7+8]
b)
Explain about B+ trees with a suitable example. Discuss about Indexed sequential Access Methods.
Aj
8.a) b)
[7+8]
Discuss about deferred database modification technique with a suitable example. What is meant by shadow paging? Discuss about check points.
6.a) List the ACID properties. Explain the usefulness of each. b) Discuss about multiple granularity. [7+8] · 7.a) Discuss the process of recovery with concurrent transactions. b) Explain about Remote backup systems. [7+8] · 8. What is meant by File organization and indexing? Discuss about Hash- based · indexing and Tree- ...
Computer Engineering, Electronics And Instrumentation Engineering .... Design the data processing unit and control unit to implement the above mentioned.
R09. Set No. 2. I B.Tech Examinations,December 2010 ... 6. A gear is accelerated from rest to a speed of 1800 rpm and then immediately · decelerated to a stop.
directions and carriers a load of 100kn at its free end. Calculate the forces ... b) Calculate the shear stress distribution in the walls of the three â cell wing section.
Calculate the · thermal efficiency of the cycle and the mean effective pressure. .... 1. (a) Determine an expansion for the heat transfer in a closed system isochoric.
Prove the theorem: Every equivalence relation R on a set generates a unique parti- · tion of the set. The blocks of this partition correspond to the R equivalence ...
(b) A gas turbine receives gases from the combustion chamber at 7.5 bar and ... (b) If turbine and pump efficiencies are 0.8 and 0.5 respectively, what is the ther-.
(b) Discuss the performance of the two magnetic coils, if the coupling coefficient ... control spring constant is 0.375 Ã 10â6 Nm/degree. Find the flux density in.
for this gases/ lb mol between the bottom and the top of the stack. .... at 750 mmHg of pressure, given that latent heat of vaporization is 88.4 cal/g. (R=1.987 ...
(a) Name and discuss atleast four important metallic properties? (b) What causes metals ... zone to room temperature and calculate the proportions of different phases and · also draw the ... solid materials? Glass is not considered as true solid.
Determine the natural frequency of the spring mass pulley radius 'r' system given .... 7.a) List various irregularities in the vehicle maintenance which lead to ...
the two limbs of the U tube containing Mercury. The difference of mercury level · in the two limbs is 170 mm. Find the speed of submarine. Assume that sea water.
8.a) Show how coded signal is obtained as an output corresponding to the changes in · position in Absolute Position Encoder. b) Draw the structure of a Photo ...
(c) Collar bone · (d) Coccyx. [4+4+4+3] · 2. What is lymph? Describe the lymphatic circulation. Explain lymphedema. [15] · 3. What are female sex hormones?
b) Explain the following business computer forensics technology ... ii) Forensic services available. ... 4.a) Explain the process of validating the forensic data?
2. (a) State the three important spectral properties of periodic power signals. .... (b) Derive the expression for Energy density spectrum function of a energy signal.
z = 0 and z = 1.5cm wrapped with 5000 turns of wire and filled with a magnetic .... (b) Determine energy stored in the electric filed of this cable when potential dif-.
1. OP AMP Applications â Adder, Subtractor, Comparator Circuits. 2. Active Filter Applications â LPF, HPF (first order). 3. Function Generator using OP AMPs. 4.
Fourier Series: Determination of Fourier coefficients Fourier series even and odd ... 4. Electrical engineering Fundamentals by Del Taro, PHI, New Delhi.
(iii) Discuss the elements of pathos in the "Dream Children A. Reverie". (iv) Give the critical ... (i) I was told about the truth. (change the voice). (ii) Neeraj said ...
