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-II
PAPER-XVIII
(Introduction to Database Management Systems)
Annual Examination, 2018
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. Draw an ER diagram for the situation given below
"In a department many employees are working on many projects, which are under control of
the manager of the department. The manager of the department also holds the responsibility
of the welfare of the employees."
Make suitable choices of the attributes for the entities, identified by you for your
ER diagram. Transform your ER diagram into a Relational Database.
2. Why do we do normalization of databases? Discuss synthesis and decomposition approaches
of normalization. Give one example for each approach.
3. Explain three level architecture of DBMS. What are the different types of data independence
involved at different levels?
4. Discuss the following with examples
Lossless Decomposition
Dependency Preserving Decomposition
5. What is the need of indices in a database system? Mention the categories of indices available
in a DBMS. Which data structure is suitable for creating indices and why?
6. Differentiate between the following
DBMS and File base systems
DDBMS and Centralized DBMS
7. Explain Serial schedule and Serializable schedule with a suitable example.
8. Explain the advantages and disadvantages of DBMS. Also discuss some applications of DBMS.
9. Describe the utility of data replication in distributed DBMS. Briefly discuss the concept of
complete and selective replication.
10. Write short notes on the following
Write Ahead Log Protocol.
Deadlock Prevention Protocols.