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
2079
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.
Design and EER model for library management system having generalization and specialization hierarchies. The EER model should have disjoint and overlapping constraints with at least one of the entities having total participation. Use your own assumption for other concepts. Now convert the EER diagram into its equivalent relational model.
What are different concepts and features of object oriented databases? What is object
relational model?
Define distributed database. What are the benefits of using distributed databases over
centralized database? Explain availability, reliability, and scalability features of distributed
databases.
SECTION B
Attempt any EIGHT question.
Why indexing is important to store data in database?What’s multilevel index?
What is aggregation? Explain with example.
Define ODMG Object model? What is Object Query Language(OQL)?
What is query processing? Differentiate query processing with query optimization.
Why query optimization is necessary? Illustrate on the choices of query execution
plans.
Why fragmentation is carried out? Difference between horizontal and vertical
fragmentation.
Why NOSQL system is essential? What are the different characteristics of this
system?
What is spatial database? Explain the concept of trigger with an example.
Write short notes on a. CAP Theorem b. Deductive database