Jawaharlal Nehru Technological University Hyderabad 2010-3rd Sem M.C.A Code No: 34 NR -ester Supplementary s DATA BASE MANAGEMENT SYSTEMS - Question Paper

 

 

 

 

 

Code No: 34

 

 

 

NR

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA-III Semester Supplementary Examinations July 2010

DATA BASE MANAGEMENT SYSTEMS

Time: 3hours Max.Marks:60

Answer any Five questions

All questions carry equal Marks

---

 

1.a)

 

b)

 

2.a)

 

b)

 

 

 

3.a)

b)

 

 

 

4.a)

b)

 

5.a)

b)

 

6.a)

b)

 

7.a)

b)

 

 

 

8.

Discuss the differences between a file-processing system and a DBMS and also

discuss their advantages and disadvantages.

Explain clearly the three levels of data abstraction.

 

Explain with suitable examples, the Cartesian-product operation, and the rename

operation in the relational algebra.

Distinguish between the Tuple relational calculus and the domain relational

calculus.

 

Develop an E-R diagram for banking enterprise.

Discuss about UML class diagrams and explain how these are different by E-R

diagrams.

 

Explain the 5th normal form, and BCNF.

Discuss the pit falls in relational-data base design.

 

Explain about Disk access using RAID Technology.

What is meant by Hashing? Explain about single- level ordered indexes.

 

Discuss how to translate a SQL query into Relational Algebra.

What is meant by query optimization? Explain algorithms for operator evaluation.

 

Explain about concurrency control based on Time stamp ordering.

Discuss about Discretionary access control based on granting and revoking

privileges.

 

Write short notes on any three of the following:

a) Database security

b) Shadow paging

c) Two-phase locking

d) ARISE recovery algorithm.

 

-oOo-