Relational Database Management System Question Paper of 3rd Semester IT(D) Download Previous Years Question Paper 2

S.B. Roll No.

RELATIONAL DATABASE MANAGEMENT SYSTEM

4^th Exam/Comp/IT/6268/Dec’10

Duration : 3 Hrs.

1.     Do as directed:

a.     DBMS stands for _________

b.     Association between two records is named as _______

c.      Relational algebra is a non procedural language (T/F)

d.     BCNF deals with multiple _______ key.

e.      Outer join operator is _________

f.       DCL sands for ___________

g.     Write syntax of DESCRIBE statement.

h.     Statement used to partially commit the current transaction and put a save point at that position  is _______

i.       Record with a unique identifier is called______

j.       __________ is the association among several entities.

k.     A single attribute or a set of attributes of a relation which can uniquely identify a record with in the relation is called________

l.       Mainly thee types of files are used in database system (T/F)

m.  Entity set having any key attributes are known as ________ sets.

n.     Symbol -  having the meaning _________

o.     Data dictionaries are of two types as – active data dictionary and ______

Section –B

Note Attempt any six questions

2.       

a.     Explain data independence and its types.

b.     Explain the meaning of following with suitable examples.

                                                             i.      Primary key

                                                           ii.      Super key

                                                        iii.      Candidate key

                                                        iv.      Foreign key

c.      List two advantages and two disadvantages of indexed – sequential file organization.

d.     Give at least five differences between DBMS and RDBMS.

e.      Define normalization. Give the properties of normalization. Give the various types of normal forms.

f.       Define functional and transitive dependency.

g.     Explain the CREATE command with syntax and example.

Section –C

Note: Attempt any three questions.

3.     Explain the term DBMS. Discuss the responsibilities of DBA. Also explain the three level architecture of DBMS.

4.     Explain Codd’s 12 rules of relational Model

. 

5.     Construct on E-R diagram for a hospital with a set of patients and set of medical doctor. Associate with each patient, a log of various tests and examinations conducted. Construct the appropriate tales for the E-R diagram.

6.     Define

a.     Data

b.     Database

c.      DBMS

d.     Entity

e.      Record