Database Management Systems (June – 2014) [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 (June – 2014) [Revised Course]

Time: 3 Hours
Total Marks: 100

N.B.:     (1) All Questions from 1 to 7 are Compulsory.
              (2) Figure To right indicate the marks.

Q.1 Given below in the Banking Schema: (10 Marks)

(A) Solve the queries below using relational algebra:

      (i) Find the names of all customers who have a loan at the Kurla Branch.

      (ii) Find the names of all customers who have a loan at the Dadar Branch but do not have an account at any branch of the bank.

      (iii) Find the names of all customers who have a loan at the Colaba Branch.

      (iv) Find the names of all customers who have a loan and an account at bank.

      (v) Find all customers who have an account at all customers located in Pune.

(B) Solve the queries below using SQL:

      (i) Find the names of all branches in the loan relations, and remove duplicates.

      (ii) Find the Name, Loan Number and Loan Amount of all customers having a loan at the Pune Branch.

      (iii) Find the names of all customers whose street includes the substring “main”.

      (iv) List in alphabetic order the names of all customers having a loan in Andheri Branch.

      (v) Find all customers who have both an account and a loan at the bank.

Q.2 Attempt Any Three From The Following: (15 Marks)

(A) What are the problems associated with file systems?

(B) What are the advantages of Relational Database Systems?

(C) What are the disadvantage of Database Systems?

(D) Explain the different types of Database Users?

Q.3 Attempt Any Three From The Following: (15 Marks)

(A) Explain the merits and demerits of Hierarchical Database Model.

(B) Explain the merits and demerits of Network Database Model.

(C) Explain the demerits of Relational Database Model.

(D) What is Data Abstraction? Explain the different levels of Data Abstraction?

Q.4 Attempt Any Three From The Following: (15 Marks)

(A) Explain the steps in Database Design Process?

(B) Explain the different types of Mapping Constraints?

(C) List & explain the different types of Keys?

(D) What is UML? Explain any 3 types of UML diagrams?

Q.5 Attempt Any Three From The Following: (15 Marks)

(A) Explain the different SET operators in Relational Algebra?

(B) Explain the various types of joins in Relational Algebra?

(C) Explain the different unary operators in Relational Algebra?

(D) Differentiate between Relational Algebra and Relational Calculus?

Q.6 Attempt Any Three From The Following: (15 Marks)

(A) Mention the different categories of Data Integrity?

(B) Explain Primary Key & Foreign Key Constraints?

(C) What is a View? What are the advantages of views?

(D) What is SQL? Explain the major categories of SQL Commands?

Q.7 Attempt Any Three From The Following: (15 Marks)

(A) Define a transaction? State the ACID properties of transactions?

(B) What states does a transaction pass through during its Lifetime?

(C) What are the disadvantages of using Lock – Based Protocols?

(D) Write short note on Time – Stamp Based Protocols.

==========================================================
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
==========================================================