University Of Pune Question Paper
M. C. M. (Semester - II): Examination - 2012
(1) Question No. 1 is compulsory.
(2) Solve any five from the remaining.
(3) Figures to the right indicate full marks.
Q.1) (A) Normalize the following upto 3NF : [12]
Blue Dart Shipping Corporation Ltd.
Invoice
Invoice No : _______ Consignee Name : ____
Date : _______ Consignee Address : ___
Vessal No. : _______ Consignor Name : ____
From _______ To _______ Consignor Address : __
Port of Loading : _______ Date of Loading : _____
Destination :
Consignment Details
Sr. No. Description UoM Quantity Packing Gross
in Pack Type Weight
Net Weight : ____
Dispatcher Signature : Receiver’s Signature
(B) Explain any 4 operations in Relational Algebra. [08]
Q.2) Explain the following terms with proper examples : [2x5=10]
(a) Degree of Relationship
(b) Composite Attribute
(c) Aggregation
(d) Weak Entity
Q.3) Explain : [5x2=10]
(a) Log Based Recovery
(b) Shadow Paging
Q.4) Explain Data Warehouse Architecture. [10]
Q.5) Explain HDM in detail. How M : M Relationship is shown in HDM ? [10]
Q.6) Explain Codd’s Rules. (Any 10) [10]
Q.7) Write short notes : (Any Two) [5x2=10]
(a) Distributed Database
(b) Assertion and Triggers
(c) Users of DBMS
(d) MVT
[4
M. C. M. (Semester - II): Examination - 2012
DATABASE MANAGEMENT SYSTEM (D.B.M.S.)
(New 2008 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :(1) Question No. 1 is compulsory.
(2) Solve any five from the remaining.
(3) Figures to the right indicate full marks.
Q.1) (A) Normalize the following upto 3NF : [12]
Blue Dart Shipping Corporation Ltd.
Invoice
Invoice No : _______ Consignee Name : ____
Date : _______ Consignee Address : ___
Vessal No. : _______ Consignor Name : ____
From _______ To _______ Consignor Address : __
Port of Loading : _______ Date of Loading : _____
Destination :
Consignment Details
Sr. No. Description UoM Quantity Packing Gross
in Pack Type Weight
Net Weight : ____
Dispatcher Signature : Receiver’s Signature
(B) Explain any 4 operations in Relational Algebra. [08]
Q.2) Explain the following terms with proper examples : [2x5=10]
(a) Degree of Relationship
(b) Composite Attribute
(c) Aggregation
(d) Weak Entity
Q.3) Explain : [5x2=10]
(a) Log Based Recovery
(b) Shadow Paging
Q.4) Explain Data Warehouse Architecture. [10]
Q.5) Explain HDM in detail. How M : M Relationship is shown in HDM ? [10]
Q.6) Explain Codd’s Rules. (Any 10) [10]
Q.7) Write short notes : (Any Two) [5x2=10]
(a) Distributed Database
(b) Assertion and Triggers
(c) Users of DBMS
(d) MVT
[4
0 comments:
Pen down your valuable important comments below