Other Master Degree-Master of Computer Management (M.C.M) 2nd Sem DATABASE MANAGEMENT SYSTEM(University of Pune, Pune-2013)
[4377]-202
M. C. M. (Semester - II) Examination - 2013
DATABASE MANAGEMENT SYSTEM
(New 2008 Pattern)
Time : 3 Hours] [Max. Marks : 70
Notes :
(1 ) Question No. 1 is compulsory.
(2) Solve any 5 from the remaining.
Q.1) (A) Normalise the following upto 3NF : [12]
Ticket No :
Train Number : Train Name :
Date of Journey : Departure Time :
Type of Journey : Bogie No. :
Sr. Name of Sex Age Seat Reservation Amount
No. Passenger No. Charges
1.
2.
3.
4.
Date : Total Amount
(B) Explain Codd’s Rule. [08]
Q.2) What is Data Model ? Explain different types of Data Models ? [10]
Q.3) What is Data Recovery ? Explain Log Based Recovery Mechanism ? [10]
[4377]-202 1 P.T.O.
Q.4) What is Data Warehouse ? Explain Architecture of Data Warehouse in detail. [10]
Q.5) Explain with example : [10]
(a) Project
(b) Generalization
Q.6) Explain the following : [10]
(a) Integrity Constraints
(b) Database Users
Q.7) Write short notes : (Any Two) [10]
(a) Distributed Database
(b) Data Mining
(c) Lock Techniques
Earning: ₹ 7.05/- |