University Of Pune Question Paper
M. C. M. (Semester - I) Examination - 2012
DATABASE MANAGEMENT SYSTEM (DBMS)
(2012 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) Kautilya University Research Group publishes an analysis of all
journal papers to Physics, Chemistry and Mathematics. Each
paper may have more than one author and man appear in only
one journal. Journals are identified by publisher details, titles,
volumes and issue number. One issue contains many papers of
many subjects. Each paper contains series of references to their
papers. Authors contribute to many papers appearing in varieties
of journals.
Draw Entity - Relationship Diagram and convert it into Relational
Database (Tables). [10]
(B) Normalize the following up to 3NF : [10]
AZZ Shipping Corporation Ltd.
Invoice
Invoice No. : [ ] Consignee Name : [ ]
Date : [–/–/–] Consignee Address : [ ]
Consignor Name : [ ]
Consignor Address : [ ]
Vessels No. : [ ] From : [ ] To : [ ]
Port of Loading : [ ] Date of Loading : [–1–1]
Destination : [ ]
Consignment details :
Sr. No. Description UOM Quantities Packing Gross
in Pack Type Weight
Net Weight : [ ]
Dispatcher Signature : Receiver’s Signature :
Q.2) Explain various characteristics of DBMS. [10]
Q.3) What is Deadlock ? Explain any one Method of Deadlock Solution. [10]
Q.4) Explain any five Fundamental Relational Algebra Operators with
example [10]
Q.5) (A) Explain Relational Model Constraints. [05]
(B) Explain Failure Classification. [05]
Q.6) (A) What is Serializable Schedule ? Explain with example. [05]
(B) What is Encryption ? Explain it with example. [05]
Q.7) Write short notes : (Any Two) [10]
(a) Data Warehousing
(b) Cardinality Ratio
(c) Database Users
M. C. M. (Semester - I) Examination - 2012
DATABASE MANAGEMENT SYSTEM (DBMS)
(2012 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) Kautilya University Research Group publishes an analysis of all
journal papers to Physics, Chemistry and Mathematics. Each
paper may have more than one author and man appear in only
one journal. Journals are identified by publisher details, titles,
volumes and issue number. One issue contains many papers of
many subjects. Each paper contains series of references to their
papers. Authors contribute to many papers appearing in varieties
of journals.
Draw Entity - Relationship Diagram and convert it into Relational
Database (Tables). [10]
(B) Normalize the following up to 3NF : [10]
AZZ Shipping Corporation Ltd.
Invoice
Invoice No. : [ ] Consignee Name : [ ]
Date : [–/–/–] Consignee Address : [ ]
Consignor Name : [ ]
Consignor Address : [ ]
Vessels No. : [ ] From : [ ] To : [ ]
Port of Loading : [ ] Date of Loading : [–1–1]
Destination : [ ]
Consignment details :
Sr. No. Description UOM Quantities Packing Gross
in Pack Type Weight
Net Weight : [ ]
Dispatcher Signature : Receiver’s Signature :
Q.2) Explain various characteristics of DBMS. [10]
Q.3) What is Deadlock ? Explain any one Method of Deadlock Solution. [10]
Q.4) Explain any five Fundamental Relational Algebra Operators with
example [10]
Q.5) (A) Explain Relational Model Constraints. [05]
(B) Explain Failure Classification. [05]
Q.6) (A) What is Serializable Schedule ? Explain with example. [05]
(B) What is Encryption ? Explain it with example. [05]
Q.7) Write short notes : (Any Two) [10]
(a) Data Warehousing
(b) Cardinality Ratio
(c) Database Users
0 comments:
Pen down your valuable important comments below