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

Code No: 34
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA-III Semester Supplementary exams July 2010
DATA BASE MANAGEMENT SYSTEMS
Time: 3hours Max.Marks:60
ans any 5 ques.
All ques. carry equal Marks
- - -
1.a) explain the differences ranging from a file-processing system and a DBMS and also
explain their advantages and disadvantages.
b) discuss clearly the 3 levels of data abstraction.
2.a) discuss with suitable examples, the Cartesian-product operation, and the rename
operation in the relational algebra.
b) Distinguish ranging from the Tuple relational calculus and the domain relational
calculus.
3.a) Develop an E-R diagram for banking enterprise.
b) explain about UML class diagrams and discuss how these are various by E-R
diagrams.
4.a) discuss the fifth normal form, and BCNF.
b) explain the pit falls in relational-data base design.
5.a) discuss about Disk access using RAID Technology.
b) What is meant by Hashing? discuss about single- level ordered indexes.
6.a) explain how to translate a SQL query into Relational Algebra.
b) What is meant by query optimization? discuss algorithms for operator valuation.
7.a) discuss about concurrency control based on Time stamp ordering.
b) explain about Discretionary access control based on granting and revoking
privileges.
8. Write short notes on any 3 of the following:
a) Database security
b) Shadow paging
c) Two-phase locking
d) ARISE recovery algorithm.

Earning:   Approval pending.