OR

Code no:411251

IV B.Tech I-Semester Supplementary Examinations. November, 2004 DATABASE DESIGN (Information Technology) Time:3 hours

Max.Marks:70

- -What are repeating groups? How are they eliminated? Explain determinants and use of determinancy diagram.

1.a) b) 2.a)

in

Answer any FIVE questions All questions carry equal marks.

Explain the following: inheritance, relationship, supertype, subtype and value set. Discuss about decomposition of many-to-many relationship.

ld .

b) 3.a)

Draw the E/R model representation of many-to-many relationship and superfluous entity tables. Explain flexing by splitting and give its advantages.

b)

Discuss about superclass, subclass relationships specialization and generalization concepts.

5.a) b)

Discuss about query processing in distributed database. Discuss about progression of database technology.

6.a) b)

Discuss the different types of traps with examples. Explain Object Oriented database design using EER-to-OO mapping with example. Discuss about data fragmentation, replication and allocation techniques for distributed database design. A database is to contain information about sales representatives, sales areas and products. Each representative is responsible for one or more area. Each area may have one or more sales representatives. Each representative sales one or more products. Draw an E/R diagram and also derive its set of base relvars definitions.

Aj

nt

8.

uW

7.

or

4.

*********