Makhanlal Chaturvedi National University of Journalism and Communication 2005 M.Sc Information Technology Data Base Management System

Duration: 3 Hours
Max. Marks: 100
Minimum Passing Marks: 40

Instructions:
1. The ques. Paper is divided into 5 units. every unit carries an internal option.
2. Attempt 1 ques. from every unit. Thus attempt 5 ques. in all.
3. All ques. carry equal marks.
4. presume suitable data wherever necessary.
5. English version should be deemed to be accurate in case of any anomaly in translation.
6.Protest against ques. paper, if any, should be lodged after paper through Head of Department Study Institute. No boycott of paper should be made under any circumstances by the examinees.

Unit-I
1.Why E-R diagrams are important ? describe the subsequent and how they are indicated in E-R diagram:
(a) Weak Entity
(b) Derived Attribute
(c) Composite Attribute
(d) Composite Key. (20)

2.Differentiate ranging from tuple calculus and domain calculus. discuss subsequent with respect to tuple calculus:
(a) Tuple Variable
(b) Range Relation
(c) Formula
(d) Expression.(20)

Unit-II
3.Primary key components are underlined:
(a) Identify and explain every of the indicated dependencies.
(b) Create a database whose tables are at lowest in two NF, showing dependency diagram for every table.
(c) Create a database whose tables are at lowest in three NF, showing dependency diagram for every table.(20)

4.Show that if a relation scheme is in BCNF, then it is in three NF, but if a relation scheme is in one NF then it is not necessarily in BCNF. provide examples.(20)

Unit-III
5.What do you understand by Query processing ? elaborate various query processing stages?(20)

6.What are distributed databases? explain various approaches of storing relations in the distributed data bases.(20)

Unit-IV
7.Explain the following:
(a) DDL and DML
(b) Integrity Constant.(20)

Unit-V
8.Explain in detail the following:
(a) Dynamic SQL
(b) Embedded SQL
(c) Transaction Control Using SQL
(d) Data Administration Statements in SQL.(20)

Unit-V
9.Explain with example every of the various kinds of cursors in ORACLE(20)

10.Write short notes on:
(a) Concurrency Control in ORACLE.
(b) Database Triggers in ORACLE.(20)

Earning:   Approval pending.