Mumbai University question papers
IV Sem CSE
Examination June 2010
Database Management System
(1) Question no. 1 is compulsory.
(2) Solve any four questions from remaining.
(3) Make suitable assumptions if needed.
1. (a) Draw an E-R diagram and reduce it to relational database model for a university database for scheduling of classrooms for final exams. This database could be modelled using entities as exam (course_name, section_number, room_number, time); course (name, department, C_number), room (r_number, capacity, building). Entity section is dependent on course.
(b) What is recoverable schedule? Why recoverability of schedule is desirable? Explain recovery with concurrent transaction?
2. (a) Explain view serializability and conflict seralizability with proper example?
(b) Explain following terms with suitable example :-
(i) Primary Key (ii) Candidate Key (iii) Foreign Key (iv) Super Key.
3. (a) For the following given database, write SQL queries :-
person (driver_id #, name, address)
car (license, model, year)
accident (reporCno, date, location)
owns (driver_id #, license)
participated (drivecid, car, report_number, damage_amount)
(i) Find the total number of people who owned cars that were involved in accident in 1995.
(ii) Find the number of accidents in which the cars belonging to “Sunil K.” were involved.
.(iii) Update the damage amount for car with licence number “Mum2022” in the accident w,ith report number “AR2197” to Rs. 5000.
(b) Explain following relational algebra with suitable example :-
(i) Natural Join
(iii) Set intersection
(iv) Generalized Projection.
4. (a) What is transaction? Discuss ACID properties of transaction?
(b) Define normalization? Explain 1NF, 2NF, 3NF and BCNF ?
5. (a) What do you mean by deadlock? What are various techniques for deadlock prevention and detection?
(b) Explain various types of constraints with an example?
6. (a) Explain Insertion of entry in B+tree?
(b) Explain various functions of a database Administrator? List five responsibilities of a DBMS?
7. Write short note on (any two) :-
(a) Generalization and specialization
(b) Buffer Management
(c) Security and Authorization in DBMS