Nalanda Open University
Annual Examination 2016
Bachelor in Computer Application Part-II
Paper-X (Database Management System)
Time: 3.00 Hrs. Full Marks: 80
Answer any Five questions. All questions carry equal marks.
fdUgha ik¡p ç'uksa ds mÙkj nhft, A lHkh ç'uksa ds vad leku gSa A
1. A university registrar's office maintains data about the following entities:
Course, including number, title, credits, syllabus and prerequisites
Course offering, including course number, year, semester, section number,
instructors, timings and classroom.
Students, including student-id, name and program.
Instructors, including identification number, name, department and title.
Construct an E R diagram for the Registrar's office. Document all assumptions that you
make about the mapping constraints.
2. Discuss the three level architecture of DBMS. Explain how it leads to data independence.
With the help of an example, explain the inverted file organization.
3. What is a view? Explain with the help of an example. Also specify the five conditions that a
view must meet in order to allow the updates.
4. Explain the concepts of Generalization and Specialization with examples. Mention the
features of OODBMS and give four advantages of it.
5. What are the general resistances faced by an organization while implementing DBMS tool?
Explain at least four of them. What is client/server computing? Discuss the components of
client/server computing.
6. Explain any three aggregate functions of SQL with an example for each. Explain the
structure of Index sequential file with the help of a diagram.
7. Explain briefly:
Dynamic Data Exchange
Object Linking Embedding
8. Illustrate the differences between hierarchical and network data models. Explain why
relational data model is a better choice over the two.
9. Explain the concept of two phase locking. Also, show that it guarantees serializability.
Define the following operations of relational algebra giving an example for each:
Division
Cartesian product
10. With the help of two examples for each, explain the use of multimedia databases and
knowledge databases. Why is the administration of a database system required? What are
the various functions associated with database administration?