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