Total No. of Questions—4] [Total No. of Printed Pages—3
Seat
No. [5361]-205
M.C.A. (Commerce) (II-Semester) EXAMINATION, 2018
205 DATABASE MANAGEMENT SYSTEM
(2013 PATTERN)
Time Three Hours Maximum Marks 50
N.B. Neat diagrams must be drawn wherever necessary.
(ii Figures to the right indicate full marks.
(iii Assume suitable data, if necessary.
All questions are compulsory.
1. Attempt any three
Define
Data
(ii Information
(ii What is view in SQL
(iii What is entity relationship model
Define Transaction.
University library have many books. Books are written by different
authors. Books are classified into different categories. Library
purchases books from specific book-sellers of different publishers.
Members of library are either staff-member or student. From
a given case study list out entities, attributes, primary keys
and relationship. Draw an E-R diagram for the same.
[5361]-205 2
2. Attempt any three
Write a note on Normalization.
Explain states of transaction with the help of suitable diagram.
What is failure Explain failure classification in detail.
What is deadlock Explain how deadlock is prevented
3. Consider the following relations and solve any two queries in
relational algebra
Customer (cno., cname, city)
Quotation qdate, description, amt-quoted, cno)
Display customer names having quotation for 'keyboard'.
(ii List all customers who lived in or 'Pimpri'.
(iii Display customers whose ant-quoted as Rs. 20000.
Consider the following relation and solve any four queries in
SQL
Employee ename, designation, salary)
Project pname)
Emp-project pno, no_of_hrs_worked)
Create table query for project table by adding primary
key constraint and project name should not be null.
(ii Add completion-date attribute in project table.
(iii Display employee details working as 'project leader'.
Insert a row in employee table.
Charge salary of employee 'Mr. Patil' to 50000.
4. Attempt any three
Write a note on data model.