Bharathiar University 2007 M.C.A RELAATIONAL DATABASE MANAEGEMENT SYSTEM - Question Paper

4090 Q.P.Code :[5 MCA 17]
(For the candidates admitted from 2005 onwards)
M.C.A.DEGREE EXAMINATION,APRIL 2007.
Second Semester

RELATIONAL DATABASE MANAGEMENT SYSTEM

Time : 3 hours Maximum : 75 marks

ans ALL ques..
part A---(10 * 1=10 marks)

1.) What is physical data independence?
2.) describe candidate key.
3.)Define cardinality of a relation.
4.) what is formula?
5.) What is DML?
6.) describe transaction.
7.) What is lossless-join?
8.) Expand DES.
9.)What is meant by pipelined parallelism?
10.) What is data skew?

part B---(5 * 3=15 marks)
ans ALL ques..

11.) (a) Compare file system versus a DBMS.
Or
(b) Write short notes on weak entities.

12.) (a) Descripe primary and foreign key constraints with suitable examples.
Or
(b) discuss briefy semantics of TRC queries.

13.) (a) What is trigger? How do you creat it ? provide an example.
Or
(b) What is schedule? elaborate the various kinds of schedules?

14.) (a) What is multivalued dependency? provide an example.
Or
(b) Write short notes on various access controls.

15.) (a) discuss briefly various kinds of distributed DBMS architectures.
Or
(b) What is substitution principle? provide an example.

part C---(5 * 10 =50 marks)
ans ALL ques..

16.) (a) (i) Explian various levels of abstraction in a DBMS. (6)
(ii) Compare entities versus attributes. (4)
Or
(b) Construct an E-R diagram ofr a univrsity registrar's office.The office maintance data about every class,including the instructor,the enrollment and place of the class meetings. For every student-class pair,a grade is recorded.Document that you make about the mapping constraints.

17.) (a) discuss any 5 relational algebra operators with suitable examples.
Or
(b) (i) Discues how do you enforce integrity constraints.
(ii) Write short notes on logical data base design.

18.) (a) (i) Descripe the specification of complex integrity constraints in SQL-92.
(ii) discuss the characteristics of transaction.
Or
(b) explain lock-based concurrency control in detail.

19.) (a) discuss BCNF and 3NF with suitable examples.
Or
(b) What is deadlock? discuss how do you prevent and detect it with suitable examples.

20.) (a) (i) explain the architecture of parallel databases.
(ii) Compare RDBMS,OODBMS and ORDBMS.
Or
(b) discuss the various ranging from RDBMS and ORDBMS database design through examples.

___________________*************************___________________

Earning:   Approval pending.