Nalanda Open University
Annual Examination 2017
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.
1. An online book database maintains the details such as ISBN, title, price, and year of
publishing, number of pages, author, and publisher of various textbooks, language books and
novels. The user can view the details of various authors and publishers. The database also
maintains the details of the ratings and feedbacks of other authors about a particular book.
The ratings of the book are displayed along with other details of the book.
Design an ERD for the Online Book Database. Assume suitable attributes for the entities and
mark the key attribute in the ERD.
2. What are distributed databases? Describe the structure of distributed databases. Describe the
issues related to storing a relation in the distributed database.
3. Write short notes on the following
Functional Dependency
Multivalued Dependency
Remote Procedure Call
Object Oriented System
4. What is a Knowledge Base System? Describe the four types of Knowledge Representation
Schemes.
5. What are the five main differences between a file processing system and a DBMS? Discuss
different types of file organization and give examples for each type.
6. Consider the two sets of FDs for the relation R E).
A AB D AC, D E
A BC, D AE
Discuss how the table can be normalized. What are the keys in the table?
7. Design Semantic Net Representation for the following facts: "Elephants are mammals. They
are large in size and have a long trunk. Their ears are large. Elephants like bananas. Appu is an
elephant but Appu likes apples.".
8. Explain any three aggregate functions of SQL with an example for each. What is ISAM How is
overflow of records handled in ISAM
9. Describe Client-Server Architecture and its advantages. What are Keys Differentiate
between Candidate, Primary and Foreign keys with the help of suitable examples.
10. Define 3NF and BCNF with examples. Consider the following relational schema
Courses Cname)
Students (Rollno, Sname, Age, Year)
Registered_for Rollno)
Write the SQL Queries for
Find the age and year of the youngest student in each year.
Display the list of students course-wise.
Display the list of students not registered for any course.