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

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

Con. 3782-12.                                                                                                       GN-7337
  
                                                    (3 Hours)                                                [Total Marks : 100]

N.B. (1) Question No.1 is compulsory.
        (2) Answer any four out of remaining questions.
        (3) Assume any suitable data if necessary and clearly state it.

1. (a) Explain object Identity and Type constructors. [5 Marks]
    (b) Explain the term Data Transparency. [5 Marks]
    (c) Explain two phase commit protocol. [5 Marks]
    (d) Differentiate between Data warehouse and Data base system. [5 Marks]

2. (a) Database is being constructed to keep track of the teams and games of a sports league.
         A team has a number of players, not all of whom participate in each game. It is desired
         to keep track of the players participating in each game for each team, the position they
         played in that game, and the result of the game.
         i) Design an EER schema, stating any assumptions you make. [7 Marks]
         ii) Show mapping of EER schema to relational schema. [5 Marks]
   
     (b) What are multidimensional database? How do this store data? [8 Marks]

3. (a) Suppose a company would like to design a data warehouse to facilitate the analysis of
         moving  vehicles in an online analytical processing manner. The company registers huge
         amounts of auto movement data int he format of (Auto ID, location, speed,time). Each
         Auto ID represents a vehicle associated with information, such as vehicle category, driver
         category, etc., and each location may be associated with a street in a city. Assume that a
         street map is available for the city.
         Design a data warehouse to facilitate effective online analytical processing and write DMQL
         for above schema. [10 Marks]
    (b) Explain with proper example nested relation in ORDBMS. [10 Marks]

4. (a) Explain in details the major steps in the ETL process. [10 Marks]
    (b) Explain design and implementation issues in mobile database. [10 Marks]

5. (a) Consider the following global schema :
                BOOKS (Book#, primary_author, Topic, Total_Stock, $price)
                BOOKSTORE (Store#, City, State, Zip, Inventory_value)
                STOCK (Store#, Book#, Qty)
        i) Give an example of two simple predicates that would be meaningful for the BOOKSTORE
           relation for horizontal partitioning.
        ii) How would a horizontal derived partitioning of STOCK be defined based on the partitioning
            of BOOKSTORE.
       iii) Show predicates by which BOOKS may be horizontally partitioned by topic.
       iv) Show how the STOCK may be further partitioned from the partitions in (ii) by adding
            the predicate in. [10 Marks]
   (b) What are the main architectures used for building parallel database? Give advantages
          and disadvantages of each. [10 Marks]

6. (a) Explain in brief the architecture of data warehouse. [10 Marks]
    (b) Consider relation R (PQRSTU) with following functional dependencies.
           P -> Q
           ST -> PR
           S -> U
           State R in which normal form? Decompose it to BCNF. [10 Marks]

7. Write short notes on : [20 Marks]
     a) Referential integrity.
     b) Authorization in SQL.
     c) Spatial Database.
     d) Temporal Database

Also see Database technologies question papers for December 2012