DBMS Question Papers of Mumbai University

I am doing BCA from the Mumbai University. I am in 4th semester. The Exam schedule is published by the University. I have completed 4th semester syllabus. But I want to solve question papers to check my preparation. So pls provide me previous years question papers of DBMS Subject of BCA Program of Mumbai University.

Hello sir I want qus paper of DBMS of Mumbai University 4th semester for practice so here can you please give me paper for practice ?

[sumit]

Hey as The University of Mumbai is one of the first three state universities in India and the oldest in Maharashtra. It is abbreviated as "MU" for Mumbai University

Here I am giving you question paper of DBMS of Mumbai University 4th semester

Question no. 1 is compulsory.

Solve any four questions from remaining.

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

(ii) Assignment

(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

(d) Hashing.


Address:

University of Mumbai

CST Road, Kalina,

Santacruz East, Mumbai,

Maharashtra 400098

Phone: 022 2654 3000