Friday, November 27, 2015

M. C. M. (Semester - I),DATABASE MANAGEMENT SYSTEM (DBMS),University Of Pune Question Paper,2012 Question Paper

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
Share This
Previous Post
Next Post

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!

0 comments:

Pen down your valuable important comments below

Search Everything Here