ADVANCE DATABASE MANAGEMENT SYSTEM (ADBMS) DECEMBER 2012 SEMESTER 5 COMPUTER SCIENCE

ADVANCE DATABASE MANAGEMENT SYSTEM (ADBMS) DECEMBER 2012 SEMESTER 5 COMPUTER SCIENCE

Con.7572-12.                                                                                                           KR-4967

                                                           (3 Hours)                                              [Total Marks: 100]

N.B. (1) Question No.1 is compulsory.
        (2) Attempt any four questions out of the remaining six questions.

1. Consider a university database that keeps track of student and their majors, transcripts and
    registration and the university courses. Several sections of each course are offered and each
    section is related to the instructor who is teaching. It also keeps track of the sponsored research
    project of faculty and graduate students of the academic departments of the particular college.
    The database also keeps track of research grants and contracts awarded to the university.
    A grant is related to one principle investigator and to all researcher it supports.
        (a) Draw an extended ER diagram for the above system. [7 Marks]
        (b) Show mapping of EER diagram into relational schema. [7 Marks]
        (c) Take two typical queries and write them in SQL. [6 Marks]

2. (a) Explain different architecture for parallel database. [10 Marks]
    (b) Explain different joins such as EQUIJOIN, NATURAL JOIN, LEFT AND RIGHT OUTER
         JOIN with suitable example. [10 Marks] 

3. (a) Explain query processing in distributed database. [10 Marks]
    (b) Explain with example nested relation in ORDBMS. [10 Marks]

4. (a) Explain heuristic query optimization with given example :- [10 Marks]
          Select e-Iname
          from Employee e, Works-on w, Project p
          where P.pname = 'Database' And
                    p.number = w.pno      And
                    e.essn      = w.ssn       And
                    e.bdate > '1977 - 12 - 31'
      (b) In SQL 3 how type inheritance and table inheritance is implemented? Explain with suitable
           example. [10 Marks]

5. (a) What is Data Transparency? Explain the type of transparencies distributed database should
          achieve. [10 Marks]
     (b) What is well formed and valid XML document? With example explain what is XML Schema
           file. [10 Marks]

6. (a) Explain Nested-loop join and Block Nested-loop join algorithm. [10 Marks]
    (b) Explain database design and implementation process. [10 Marks]

7. Write short notes on (any four):- [20 Marks]
     (a) Replication in distributed DBMs.
     (b) Aggregate functions in SQL.
     (c) XML schema elements.
     (d) EXIST and NOT EXIST clause in SQL.
     (e) Query processing in typical DBMs system.