Database Technologies - May 2012

Information Technology (Semester 6)

TOTAL MARKS: 100
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any four from the remaining questions.
(3) Assume data wherever required.
(4) Figures to the right indicate full marks. 1 (a) Explain Object Identity and Type Constructors.(5 marks) 1 (b) Explain the term Data Transparency.(5 marks) 1 (c) Explain two phase commit Protocol.(5 marks) 1 (d) Differentiate between Data warehouse and Database 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 positions they played in that game, and the result of the game.
(i) Design an EER schema. stating any assumptions you make.
(ii) Show mapping of EER schema to relational schema. (12 marks) 2 (b) What are multidimensional databases? How do these 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 in the 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) 3 (b) Explain with proper example Nested relation in ORDBMS.(10 marks) 4 (a) Explain in detail the major steps in the ETL process.(10 marks) 4 (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 predicates in (iii).(10 marks) 5 (b) What are the main architectures used for building parallel Databases? Give advantages and disadvantages of each.(10 marks) 6 (a) Explain in brief the architecture of data warehouse.(10 marks) 6 (b) Consider relation R (PQRSTU) with following functional dependencies.
P → Q
ST → PR
S → U
State R is in which normal form? Decompose it to BCNF.(10 marks)

Write short notes on (any two)

7 (a) Referential Integrity.(10 marks) 7 (b) Authorization in SQL.(10 marks) 7 (c) Spatial Databases.(10 marks) 7 (d) Temporal Databases.(10 marks)