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
(MCS-023 Introduction to Database Management Systems)
Annual Examination, 2017
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. Consider the following relations
hotel (hotel_no, hotel_name, city)
room (room_no, hotel_no, type, price)
booking (hotel_no, guest_no, date_from, date_to, room_no)
guest (guest_no, g_name, g_address)
Write appropriate Queries in SQL as well as in relational algebra, for the following
Find the average price of a room
List the names and address of all guests with bookings for a hotel in London,
alphabetically ordered by name.
Find the total income from all the rooms of the hotels in New York
List the name(s) of guest(s) at the Winner Hotel, who are paying highest price for a
room.
2. Why is normalization important Differentiate between BCNF and 3NF. Why BCNF is
considered as a stronger form of 3NF
3. Briefly discuss the concept of catalogs in distributed databases. How catalogs are used to
maintain the consistency of database in a distributed environment. Use suitable example to
justify your answer.
4. Design an ER diagram for keeping track of the details of your favorite sports team. You should
store the matches played, the score in each match and individual player statistics for each
match. Identify the entities, relationships and also mention the cardinality of ER diagram.
5. How serial schedule is different from serializable schedule? What are the problems associated
with both schedules How you will identify that a schedule is serializable or not, use suitable
example, in support of your answer.
6. What are the additional functions does a distributed DBMS have over centralized DBMS
Describe the shadow paging recovery technique. Under what circumstances does it not
require a log
7. What is a view in SQL How is it defined Discuss the problems that may arise when one
attempts to update a view.
8. What is the difference between centralized and client-server architectures? How relational
DBMS is evolved from the centralized architecture to the client server architecture? What for
ODBC is used in this context
9. What do you mean by the term "TRANSACTION" in DBMS? Briefly discuss the properties of
transaction Violation of which property leads to which problem, when transactions are
executed in a concurrent environment.
10. Write short notes on any Two of the following
2 Phase locking
2 Phase commit
Time stamping
Check