University Of Pune Question Paper
M.C.A. (Semester – II) (Mgt. Faculty) Examination, 2010
IT-24 : DATABASE MANAGEMENT SYSTEM
(2005 Pattern) (Old)
Time : 3 Hours Max. Marks : 70
Instructions : 1) Q. 1 is compulsory.
2) Solve any 5 from remaining questions.
3) State assumptions and draw well labelled diagrams wherever
necessary.
1. a) A company has set of departments. Each department has a set of employees,
a set of projects and a set of offices. Each employee has a job history (set of
jobs that employee has held). For each such a job the employee also has
salary history (set of salaries received while employeed on that job). Each
office has a set of phones. Normalize the above case upto 3-NF. 15
b) State Codd's rule. 5
2. What is data abstraction ? Explain data view levels. Also explain view and schema. 10
3. Explain M : N resolution of NDM, HDM and RDM. 10
4. Explain log based recovery. 10
5. Explain the following : 10
a) Object oriented d/b
b) Security and privacy of database.
6. Explain any two of the following : 10
1) Knowledge database
2) Datawarehouse schema
3) Aggregation.
7. Write short notes on (any two) : 10
1) Database users
2) Join and its types
3) 2-phase commit protocol
4) Transaction, properties and states.
————————
M.C.A. (Semester – II) (Mgt. Faculty) Examination, 2010
IT-24 : DATABASE MANAGEMENT SYSTEM
(2005 Pattern) (Old)
Time : 3 Hours Max. Marks : 70
Instructions : 1) Q. 1 is compulsory.
2) Solve any 5 from remaining questions.
3) State assumptions and draw well labelled diagrams wherever
necessary.
1. a) A company has set of departments. Each department has a set of employees,
a set of projects and a set of offices. Each employee has a job history (set of
jobs that employee has held). For each such a job the employee also has
salary history (set of salaries received while employeed on that job). Each
office has a set of phones. Normalize the above case upto 3-NF. 15
b) State Codd's rule. 5
2. What is data abstraction ? Explain data view levels. Also explain view and schema. 10
3. Explain M : N resolution of NDM, HDM and RDM. 10
4. Explain log based recovery. 10
5. Explain the following : 10
a) Object oriented d/b
b) Security and privacy of database.
6. Explain any two of the following : 10
1) Knowledge database
2) Datawarehouse schema
3) Aggregation.
7. Write short notes on (any two) : 10
1) Database users
2) Join and its types
3) 2-phase commit protocol
4) Transaction, properties and states.
————————
0 comments:
Pen down your valuable important comments below