Monday, 14 July 2014

ADVANCED CONCEPT IN DATABASES

MCSE/MSE-203
                                                  M.E./M.tech. ( Second Semester)
                                                      Examination, June-2012
                                                  (Grading /Non Grading System)
          ADVANCED CONCEPT IN DATABASES
                                                  (MCSE-203)


Time: three hours                                                                                   Maximum Marks: GS: 70
                                                                                                                                         NGS:100



NOTE: attempt any five questions. all question carry equal mark.


1.  (a)  why is the normalisation process necessary for a good database design ?  discuss   in detail the boyce-codd normal form with suitable example.
    (b)  explain the basic relational algebra operations with the symbol used and an example for each.
2.  (a)  explain inter-query parallelism.
    (b)  what is an ER diagram ?   construct an ER diagram for a hospital with a set of  patients and set of doctors. associate with each patients and a set of doctors associate
with each patient a log of the various tests and examination conducted.
3.  (a)  explain deadlock handling in distributed database?
    (b)  explain distributed query processing.
4.  (a)  how are the object oriented databases beneficial than the traditional database?  explain the different concepts of object oriented database management systems.
    (b)  how a distributed database can be recovered in case of failure ?
5.  (a)  discuss cost estimation in query optimization.
    (b)  discuss in detail the architecture of  data warehouse.
6.  (a)  write in brief bayesian classifiers.
    (b)  what is a multimedia database? explain the methods of mining multimedia
      database.
7.  (a)  what are the objectives of data mining? discuss spatial data mining.
    (b)  differentiate between star and snowflake schemas.
8.  (a)  write short notes on any four of the following :
        (1)  web database
        (2)  distributed data marts
        (3)  ORDBMS design
        (4)  data mining techniques
        (5)   mobile databases.


No comments:

Post a Comment