Database Management Systems (October – 2016) [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 (October – 2016) [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 four from Q.2 – Q.7.
            (3) Draw Neat and Labelled Diagram whenever necessary.

Q.1 Attempt Both The Question: (10 Marks)
(A) What is Normalization? Explain 1NF and 2NF Normalization with example.
(B) Construct an E-R Diagram for a Car-Insurance Company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents.

Q.2 Attempt Any Three From The Following: (15 Marks)
(A) Define Database System. What is the purpose of Database System?
(B) What are the advantages and disadvantages of Database System?
(C) What is Transaction Management? Explain it with example.
(D) Explain the view of Data in DBMS.

Q.3 Attempt Any Three From The Following: (15 Marks)
(A) Write short note on degrees of Data Abstraction.
(B) Define Data Model. Explain the Data Model in detail.
(C) Describe the Basic Building Blocks of Data Model.
(D) Explain the Business Rules for Data Model.

Q.4 Attempt Any Three From The Following: (15 Marks)
(A) Define the following terms:
      (i) Tuple
      (ii) Attribute
      (iii) Domain
      (iv) Primary Key
      (v) Foreign Key
(B) Explain Weak Entity and Strong Entity with example.
(C) What are the features of Good Relationship Database Design Normalization?
(D) List the Codd’s Rules and explain any two in detail.

Q.5 Attempt Any Three From The Following: (15 Marks)
(A) Explain Selection and Projection in Relational Calculus.
(B) Distinguish between Relational Algebra and Relational Calculus.
(C) Explain any two set operation with example.
(D) Write the equivalent relational algebra expression for any three given below quires.
Loan(loan_no, branch_name, loan_amount, customer_no)
Customer(customer_no, customer_name, city)
      (i) Find all loan numbers for loans with an amount greater than $1200.
      (ii) Find branch name, loan number, customer name and amount for loans of below $5000.
      (iii) Find all customers having a loan from the MTU branch, and the city in which they live.

Q.6 Attempt Any Three From The Following: (15 Marks)
(A) What is trigger? Explain it with syntax and example.
(B) What is join? Explain equijoin and non-equijoin with example.
(C) Explain the aggregate functions in SQL are as follows:
      (i) AVG(),
      (ii) COUNT()
      (iii) MAX()
      (iv) MIN()
      (v) SUM()
(D) Write short note on:
      (i) Data Integrity
      (ii) Check Constraint
      (iii) Not null constraint

Q.7 Attempt Any Three From The Following: (15 Marks)
(A) Explain Acid properties in detail.
(B) Draw the Transaction State Diagram and explain different states of Transaction.
(C) What is Serializability? Explain Serializability Schedule Classification of Conflict Serializability and View Serializability.

(D) What is Time Stamping? Explain.

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