Rajiv Gandhi Proudyogiki Vishwavidyalaya 2007-2nd Sem M.C.A Computer Aplications .(ester) ,.-., - university paper

MCA-202
M.C.A.(Second Semester) Examination,Nov.-Dec.,2007
DATABASE MANAGEMENT SYSTEM
(MCA-202)
Time : 3 Hours
Maximum Marks : 100
Minimum Pass Marks : 40

Note : Attempt any 2 parts of every ques.. All ques. carry equal marks.

1.(a) describe Database Management System(DBMS).Discuss the responsibilities of DBA.
(b) Software India Ltd. is an organization involved in the design, development and marketing of
software products for a family of advanced personal computers.What entities are of interest
to such an enterprise ? provide a list of these entities and the relationship among them.
(c) describe the subsequent :
(i) E-R Model
(ii)DBMS architecture

2.(a) explain various kinds of key. For every case, provide a suitable example. What is a foreign key
constraint ? Why is such constraint important ?
(b) discuss the subsequent :
(i) SQL and its operation
(ii) Relational calculus
(c) What do you understand by Query processing and optimization ? explain in detail.

3.(a) Why do we need normailized data ? What is BCNF ? explain.
(b) Consider a relation R(A.B.C.D.E.). The subsequent dependencies are provided :
A -> B, BC -> E, ED ->
obtain all keys of relations R. Is R in BCNF ? Justify your ans.
(c) discuss the subsequent :
(i) Multivalued dependencies
(ii) Dependency preservation

4.(a) explain different transaction states with their description and state diagram.
(b) discuss the subsequent :
(i) ACID properties
(ii) Checkpoints
(iii) Data fragmentation
(c) Enlist various schemes of database recovery and discuss any 1 in detail.

5.(a) What do you understand by file organization ? explain various approaches of file
organization along with their merits and demerits.
(b) discuss the subsequent :
(i) Object Oriented Database
(ii) Video servers
(iii) Data warehousing
(c) discuss the difference ranging from every of the subsequent
(i) Primary versus secondary indexes
(ii) Dense versus sparse indexes
(iii) Clustered versus unclustered indexes

Earning:   Approval pending.