Total No. of Questions—5] [Total No. of Printed Pages—2
Seat
No. [5367]-104
M.C.M. Sem.) EXAMINATION, 2018
104 DATABASE MANAGEMENT SYSTEM
(2013 PATTERN)
Time 2½ Hours Maximum Marks 50
N.B. Question Nos. 1 and 5 are compulsory. Solve any two questions
from remaining.
(ii Figures to the right indicate full marks.
1. A bank has many branches and a large number of customers. A
customer can open different kinds of accounts with the bank. The
bank keeps track of customer by his SSN, Name, address and phone
number. Age is used as a factor to check whether he is major.
There are different types of loan, each identified by loan number.
A customer can take out more than one type of loan, and all branches
can give loan. Loans have duration and interest rate.
The account holder can enquire about the balance in his accounts.
Draw an E-R diagram for above case and normalized upto
3NF.
2. What is concurrency control Explain time stamp based protocols
with example.
P.T.O.
[5367]-104 2
3. Explain the following keys with example
Primary key
Secondary key
Candidate key
Super key
Foreign key.
4. Explain log base recovery.
Explain how concurrent transactions are recovered.
5. Write short notes on (any three)
Database users
Transaction states
E.F. Codd's rule (any five)
Data warehousing
Encryption.