B.Tech-B.Tech Electrical Engineering 7th Sem 7EEl Data Base Management System(Rajasthan Technical University-2011)
7E4171
B. Tech. VII Semester (Main/Back) Examination, Nov-Dec - 2011
Electrical Engineering
7EEl Data Base Management System
Time: 3 Hours Maximum Marks: 80 Min. Passing Marks : 24
Unit - I
Q.1. a) What are the advantages and disadvantages of a database approach?
b) Draw and explain the architecture of DBMS
c) Define data independence? Explain various types of data independence? [6+6+4]
OR
Q.1. a) Differentiate between a file system and database oriented system.
b) Explain various kinds of symbols used in ER diagram
c) Differentiate between weak and strong entity.
d) Differentiate between Specialization and generalization with help of an example. [4+4+4+4]
Unit - II
Q.2. a) Define relational algebra. Explain briefly various set operations?
b) Explain Natural join and Rename operator with respect to Relational Algebra with the help of examples.
c) Consider the following relational database
Employee (person-name, street, city)
Works (person-name, company name, salary)
Company (company-name, city)
Manager (person-name, manager name)
Give relational algebra expression for each of the following queries:
i) Find the company that has the most employees.
ii) Find the company that has the smallest payroll.
iii) Find names, cities of residence of all employees who work for first Bank Corporation. [6+4+6]
OR
Q.2. a) What is normalization? Discuss all the normal forms with the help of examples.
b) Explain why 4NF is a more describe normal form than BCNF? [10+6]
Unit - III
Q.3. a) What do you mean by .conditional Assertions? In Application development using SQL, how host language interface is created.
b) What do you mean by view in SQL? Write syntax to create view.
c) Differentiate between stored procedure and triggers. How stored procedure and triggers are created ?Explain with examples. [6+4+6]
OR
Q.3. Write short note on the followings
a) Dynamic SQL
b) JDBC
c) DDL
d) DML [4x4]
Unit - IV
Q.4. a) How we can reduce the occurrence of bucket overflow in a hashed file organization
b) Explain how indexed file organization takes place. Write down its advantage and disadvantages.
c) Explain Dense and Sparse index. [6+6+4]
OR
Q.4. a) What are the advantages of hashing ? Explain static and dynamic hashing
b) Explain inverted and multi-structure in details? [6+10]
Unit- V
Q.5. a) What do you mean by Transaction? Write down various desirable properties of a Transaction.
b) Describe UNDO and REDO operations.
c) How does the granularity of data item affect the performance of concurrency control? Explain multiple granularity level locking in detail? [4+4+8]
OR
Q.5. a) How deadlock are detected? Explain in details
b) Explain log based recovery technique? [8+8]
| Earning: ₹ 5.00/- |
