DATABASE TECHNOLOGIES (DBT) MAY 2013 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) MAY 2013 SEMESTER 6TH INFORMATION TECHNOLOGY

Con. 7342-13.                                                                                               GS-1006

                                                       (3 Hours)                                              [Total Marks: 100]

N.B.: (1) Question No.1 is compulsory.

         (2) Attempt any four questions of remaining six questions.

         (3) Assume suitable data if required.

         (4) Figures at right indicate full marks

1. (a) Explain object identity and type constructor. [5 Marks]

    (b) Suppose that we decompose the Schema R = { A, B, C, D, E } into: [5 Marks]

                     R1 = { A, B, C } and 

                     R2 = { A, D, E } 

         Show that the decomposition is lossless join decomposition if the following set 

         F of functional dependencies holds.

                     A -> BC

                     C -> E

                     B -> D

                     E -> A

    (c) Explain factless fact table with example. [5 Marks]

    (d) Explain BCNF with suitable example. [5 Marks]

2. (a) Describe the event-condition-action model for triggers. Why triggers are required? [10 Marks]

    (b) Consider a dependency diagram of  Relation R. [10 Marks]

          (i) The relation R in which normal form? Justify your answer.

          (ii) Normalize relation R upto third normal form 

3. (a) Explain design and implementation issues in Mobile Database. [10 Marks]

    (b) Explain in detail the major steps in the ETL process. [10 Marks]

4. (a) Explain the concept of referential integrity with suitable example. [10 Marks]

    (b) Consider an employee table with a multivalued dependents attribute employee. [10 Marks]

          i) Define employee table using nasted relation  in ORDBMS or OODBMS. 

         ii) Comment on the normalization rule violation if we define nested relation .

5. (a) Explain the architecture of Data warehouse in detail. [10 Marks]

    (b) Given the relation R with attributes A to J and the following set of funtional   

          dependencies:- [10 Marks]

           FD = {{A, B}     ->    {c},

                      {B, D}     ->    {E, F},

                      {A, D}     ->    {G, H},

                      {A}          ->    {I},

                      {H}          ->    {J}}

      (i) What is the key of relation R.

      (ii) Decompose Relation R into 2NF and 3NF.

6. (a) Write short note on temporal database. [10 Marks]

    (b) Consider following Schema and PROJECT relation instance. [10 Marks]

        Pay

Project

    (i) Apply primary horizontal fragmentation (PHF) to PROJECT realtion.

    (ii) Clearly state the different minterm predicates. 

    (iii) State and derive the implcation of  minterm predicates.

7. (a) Explain authorization in SQL. [5 Marks]

    (b) Compose primary key and object identity. [5 Marks]

    (c) Compass Data warehouse and Data marts. [5 Marks]

    (d) Write short note on parallel Database. [5 Marks] 

Also see Database technologies question papers for December 2011