Bharathiar University 2006 M.C.A RELATIONAL DATABASE MANAGEMENT SYSTEM - Question Paper

1227 [05 MCA 17]

(For the candidates admitted from 2005 onwards)

M.C.A. DEGREE EXAMINATION, APRIL 2006.
2nd Semester

RELATIONAL DATABASE MANAGEMENT SYSTEM

Time : 3 hours Maximum : 75 marks

ans ALL ques..

part A---(10 * one =10 marks)

1.) What do you mean by the degree of a relation?
2.) What is logical data independence?
3.) What is a single-valued attribute? provide example.
4.) What is an atom?
5.) What is a trigger?
6.) What is a null?
7.) What is a many-to-may relationship? provide example.
8.) What is a time out?
9.) What do you mean by " Inheritance "?

part B---(5 * three =15 marks)

11.) (a) Why do we neeed a DBMS?
Or
(b) elaborate the 3 characterstics of the relational data model?

12.) (a) How does tuple relational calculus differ from domain relational calculaus?
Or
(b) How are views various from base tables?

13.) (a) How are rows grouped, based on a few criteria? provide examples.
Or
(b) How are duplicates eliminates from the UNION outcome set?

14.) (a) What is an inseration anomaly? provide example.
Or
(b) elaborate the various dimensions of security?

15.) (a) elaborate the disadvantages of distributed database systems?
Or
(b) What is synchronization and why is it necessary?

part C---(5 * 10 =50 marks)

16.) (a) Compare and contrast in ranging from file systems and database management systems.
Or
(b) Illustrate the conceptual database design with the ER model.

17.) (a) Illestrate the procedure to convert E-R Diagram to Rleational model with a suitable example.
Or
(b) Expalin the different operations involved in Relational algebra with examples.

18.) (a) Write the general syntax of complete choose statement and discuss every choice with suitable example.
Or
(b) What do you mean concurrency control? discuss the different concurrency control mechanisms based on locking.

19.) (a) Expalin the schema refinement process in database design.
Or
(b) Descripe about the access control of database .

20.) (a) discuss the distributed DBMS architecture.
Or
(b) Illustrate parallel query optimization process.

Earning:   Approval pending.