Advanced Database
This course includes advanced concept of database system. The main topics covered are advanced concept of relational data model, Extended E-R model, new database management technologies, query optimization, NoSQL database and big data processing techniques.
Tribhuvan University
Institute of Science and Technology
Model Set
Bachelor Level / eight-semester / Science
Computer Science and Information Technology( CSC461 )
Advanced Database
Full Marks: 60 + 20 + 20
Pass Marks: 24 + 8 + 8
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.
Section A
Attempt any TWO questions.
Explain enhanced entity relationship model in detail. What is aggregation?
What is distributed database? Explain data fragmentation techniques in detail with suitable example.
Why do we need query optimization in databases? Compare heuristic query optimization with cost-based query optimization.
Section B
Attempt any EIGHT questions.
Explain specialization and generalization with example.
What are the benefits of object-oriented database? What is object identity?
Explain object query language (OQL) with suitable example.
What is query tree? Why do we need this tree in query processing?
Explain different techniques for distributed database design.
Explain document-based NOSQL system with example.
Explain multimedia database in brief. What are the different applications of multimedia database?
Why do we need temporal database? Explain different time dimensions in this database.
Write short notes on:
a) Indexing
b) MapReduce