M.C.A-M.C.A 2nd Sem IT - 22 : 202 : DATABASE MANAGEMENT SYSTEM(University of Pune, Pune-2013)

M.C.A. (Semester - II) (Management Faculty) Examination, 2013

IT - 22 : 202 : DATABASE MANAGEMENT SYSTEM

(2012 Pattern)

Time : 3 Hours                                                                                                             Max. Marks : 70

Note : 1) Q. No. 1 is compulsory.

2) Solve any five questions fromremaining.

3) State assumptions wherever necessary.

1. An Educational institute wants to computerize its student management system.

The details are as follows :

1) Institute has departments.

2) Department conducts various full time courses.

3) Department has various teachers teaching subjects of various courses.

4) Course has subjects with unique code.

5) Student appear for an exam for which he gets result.

For the above case, draw the E-R diagram and normalized (3NF) file layout.

2. Explain E.F. Codd's rules.

3. Explain the concept of deadlock. Explain how it is detected and prevented.

4. Explain log-based recovery techniques in detail.

Add comment