Advanced Database Management System 2069

Tribhuwan University
Institute of Science and Technology
2069
Bachelor Level / Seventh Semester / Science
Computer Science and Information Technology ( CSC-401 )
( Advanced Database Management System )
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.

Attempt all the questions.

1) Explain the following terms:

     a) Data mining

     b) ECA model

     c) Spatial database

     d) Specialization and generalization in an ERR model

     e) XML and HTML

     f) GIS

6 marks view

2) How can you convert an ERR design to relational design? Discuss with suitable example.

6 marks view

3) What is OID? How persistent objects are maintained in OO Database?

6 marks view

4) Discuss the relative advantages of centralized and distributed database.

6 marks view

5) Describe different implementation issues with object relational database system.

6 marks view

6) Discuss the different techniques for executing equijoin of two files located at different sites. What main factors affect the cost of data transfer?

6 marks view

7) Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.

6 marks view

8) Distinguish object-oriented database and object relational databases.

6 marks view

9) What is a data warehouse? How does it differ from a database?

6 marks view

10) Explain mobile computing architecture with suitable diagram.

6 marks view