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

S.B. Roll No.

RELATIONAL DATABASE MANAGEMENT SYSTEM

4^th Exam/Comp/IT/6268/May’08

Duration : 3 Hrs.

          Note : There are questions in all.

·        Question 1 is compulsory and carries 15 marks.

·        Attempt any five question form section B and three question form section C.

·        Any required data not explicitly given , may be suitably assumed and stated.

1.     Choose the correct or best alternative in the following:

a.     The property /properties of a database is/ are:

b.     It is an intergrated collection of logically related records.

c.      It consolidates separate files into a common pool of data records.

d.     All of the above.

e.      The DBMS language component which can be embedded in a program is

                                                             i.      The data definition language (DDL) 

                                                           ii.      The data manipulation language (DML)

                                                        iii.      The database administrator (DBA)

                                                        iv.      A query language.

f.       A relational database developer refers to a record as

                                                             i.      A criteria

                                                           ii.      A relation

                                                        iii.      A tuple.

                                                        iv.      An attribute.

g.     The relational model feature is that there

                                                             i.      Is no need for primary key data

                                                           ii.      Is much more data independence than some other database models.

                                                        iii.      Are explicit relationships among records.

                                                        iv.      Are tables with many dimensions

h.     Conceptual design

                                                             i.      Is a documentation technique

Needs data volume and processing frequencies to determine the size of the database

Involves modeling independent of the DBMS

Is designing the relational model  .

i.       The method in which records are physically stored in a specified order according to a key field in each record is

                                                             i.      Hash

                                                           ii.      Direct

                                                        iii.      Sequential

                                                        iv.      All of the above

j.       A subschema expresses

                                                             i.      The logical view

                                                           ii.      The physical view.

                                                        iii.      The external

                                                        iv.      All of the above

k.     Count function in SQL returns the number of

                                                             i.      Values.

                                                           ii.      Distinct values.

                                                        iii.      Groups.

                                                        iv.      Columns.

Section –B

2.     Discus the main advantages of using a DBMS.

3.     What are the different types of database and user? Discuss the main activates of each

4.     Describe the three-schema architecture

5.     Discuss the typical user friendly interfaces and the types of users who use each.

6.     Differentiate between    

Procedural and non procedural languages

Key and super key.

  Primary and secondary storage.

7.     With the help of an example show how records can be deleted and updated in QBE

8.      

a.     Describe cardinality ratios and participation constraints for relationship types.

b.     Information about a bank is about customers and their account. Customer has a name, address which consists of house number , area and city , and one more phone numbers, account has number, type and balance. We need to record customers who own an account , Account can be held individually or jointly . an account cannot exist without a customer.

Arrive at an E-R diagram. Clearly indicate attributes, keys, the carnality ratios and participation constraints.

9.      

a.     Describe the static hash file with buckets and changing and show how insertion, deletion and modification of a record can be performed. 

b.     What are the reasons for having variable length records? What types of separator characters are needed for each?

10.                        Define the following terms

Derived and stored attribute.

Distributed system.

Interlock gap

Degree of a relation

Catalog

Conceptual schema

11.                          

a.     Define a relation

b.     Describe entity integrity and  referential integrity. Give an example of each

c.      Consider the two relations given below

R S

A	B	C
A1 Null A1	B1 B2 B3	C1 Null C1

D	A	F
D1 D1	A1 A2	F1 Null

Given that A is the primary key of R, D is the primary key of S and there is a referential integrity between S.A and R.A, discuss all integrity constraints that are violated.