Database Management Systems (April – 2015) [IDOL - Revised Course | Question Paper]

Click Here: (PDF Link 1) | Click Here: (PDF Link 2) | Click Here: (PDF Link 3)

Click Here: (Image View) | Click Here: (Text View)

B.Sc.IT: Semester – II

[Database Management Systems]

Question Paper (April – 2015) [Revised Course]

Time: 3 Hours
Total Marks: 100

N.B.:   (1) All Questions from 1 to 7 are Compulsory.
            (2) Attempt any three sub questions out of 4 from Q.2 to Q.7.
            (3) Draw neat and labelled diagram whenever necessary.

Q.1 Attempt Both The Question: (10 Marks)
(A) Explain ACID properties.
(B) Explain any five E.F Codd’s Rules.

Q.2 Attempt Any Three From The Following: (15 Marks)
(A) What is Database System? List any two Database System Applications.
(B) What is the Purpose of Database Management System?
(C) Draw and describe architecture of Database System Structure.
(D) Write short note on Transaction Management.

Q.3 Attempt Any Three From The Following: (15 Marks)
(A) What are the degrees of Data Abstraction? Explain.
(B) Explain the merits and demerits of Network Database Model.
(C) Explain the Business Rules.
(D) Explain the Hierarchical Database of Data Model.

Q.4 Attempt Any Three From The Following: (15 Marks)
(A) State and explain Relational Integrity Rules.
(B) Draw ER Diagram for educational Institute database consisting of four Entities Student, Department, Class, Faculty. Student has a unique id, the student can enroll for multiple classes and has a most one major.
      (i) Faculty must belong to department and faculty can teach multiple classes.
      (ii) Each class is taught by only faculty.
      (iii) Every student will get grade for the class he/she has enrolled.
(C) Define the following terms:
      (i) Aggregation
      (ii) Generalization
      (iii) Specialization
(D) What is Normalization? State and explain its forms briefly.

Q.5 Attempt Any Three From The Following: (15 Marks)
(A) What is join? Explain the different types of joints with example.
(B) Explain Tuple Relational Calculus and Domain Relational Calculus.
(C) Explain any two set operations with syntax and example.
(D) Write note on following terms with example:
      (i) Select Operation
      (ii) Project Operation

Q.6 Attempt Any Three From The Following: (15 Marks)
(A) What is Constraint? State and explain any two Constraints with example.
(B) Explain how to create and drop view with syntax and suitable example.
(C) Explain any four aggregate function with example.
(D) Explain triggers with suitable examples.

Q.7 Attempt Any Three From The Following: (15 Marks)
(A) Define Deadlock? What are the different methods used to recover from Deadlock?
(B) What are the different types of Transaction State? Explain.
(C) Explain Time Stamping methods in detail.

(D) Explain Concurrency Control in detail.

==========================================================
Follow "Mumbai B.Sc.IT Study" @
• YouTube: Click Here
• Facebook: Click Here
• Instagram: Click Here
• Twitter: Click Here
• Slideshare: Click Here
• Tumblr: Click Here
• Flickr: Click Here
• Pinterest: Click Here

Follow "Kamal T." @
• Facebook: Click Here
• Instagram: Click Here
• Twitter: Click Here
• LinkedIn: Click Here
• VK: Click Here
• Behance: Click Here

• Snapchat: skmkamal

NOTE:
If You're a B.Sc.IT Student of Mumbai University...and you've a previous year question papers then please mail us @ kamalbscit@yahoo.in
==========================================================