N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-III
PAPER-XXII
(MCS-043 Advanced Database Design)
Annual Examination, 2017
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. Construct an E-R diagram for a training institute which imparts soft skills. The institute
maintains records about instructors, students, classes, assignments, results (Theory as well as
practicals) class timings for each student. The number of subjects, in which the candidate is
enrolled and past performances in different subjects is recorded. Document all assumptions
that you make about the mapping constraints.
2. How is the check pointing information used in the recovery operation following a system crash
in DBMS? Explain.
3. Explain the concept of inheritance in object oriented database system, with the help of an
example. How can you protect your database from statistical query attacks?
4. Distinguish between the followings with appropriate examples.
Centralized two phase locking and Distributed two phase locking.
XML and HTML
5. What is multimedia database? What are challenges in designing multimedia databases? Discuss.
6. Describe the reference architecture of a distributed DBMS with the help of a block diagram.
7. What is semi structured data? Explain with an example. Define Hash join and explain the
process and cost calculation of Hash join with the help of an example.
8. Describe two phase commit protocol in distributed databases. List the features of semantic
database.
9. Discuss the 5th normal form and domain key normal form with a suitable example in each.
10. What do you mean by deadlock in DBMS? How can you detect a deadlock? Suggest a
technique that can be used to prevent it.