Guru Gobind Singh Indraprastha Vishwavidyalaya 2010 B.B.A Dbms - Question Paper

Subject: DBMS

Maximum Marks: 75

answer type:    (5x3=15)

What is data redundancy? Explain.

Discuss various types of keys in relational data model.

Distinguish between logical and physical data independence.

What are the rules for decomposition of relations? Explain.

How does the concept of an object in the object oriented model differ from the concept of an entity in the entity relationship model?

Unit-I

What are the major functions performed by the DBMS? Explain.    (10)

Explain the role of database administrator.    (5)

Explain the three tiered architecture of relational model.    (10)

Explain the advantages of DBMS over a file system.    (5)

Unit-I I

Explain the 12 Codd Rules for relational model.    (10)

What are database views? How the views are created? Explain.    (5)

Design an ER diagram for keeping track of the exploits of your favourite cricket team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Convert it

Short

(a)

(b)

(c)

(d)

(e)

Q1.

Q2.

Q3.

Q4.

Q5.

(a)

(b)

(a)

(b)

(a)

(b) (a)

to tables.

Explain various attribute types.

(10)

(5)

(b)

(a)

(b) (a)

Unit-Ill

Q6.

Q7.

What is normalization? Explain third normal form with a suitable example. (10) What is schema refinement? Explain.    (5)

What Is functional dependency? Given Relation R (A, B, C, D, E) satisfies that

following functional dependencies:    (10)

AB -> C

C - A

BC -> D

ACD ~ B

BE ->C

Find out the closure of FDs.

What are various types of anomalies that can occur in a relational database? How they can be removed? Explain with an example.    (5)

(b)