Pandit Ravishankar Shukla University 2010 B.Sc Computer Science Ptravishankar shukla university, BSc.(Part III) , , , Second , DBMS and RDBMS - Question Paper

B. Sc. (Part III) Examination, 2010
COMPUTER SCIENCE
Paper Second
(DBMS and RDBMS)

Time: 3 Hours ] [Maximum Marks:50

NOTE: Draw improper table as an example and draw neat diagram whenever possible to justify your ans. presume data if necessary. Solve any 2 parts from every ques.. ques. having equal marks.

1. (a) discuss the different advantages of D.B.M.S. system.
(b) elaborate the different important activities that take place to execute single transaction ?
(c) discuss the weak and strong entity set using suitable example.

2. (a) Compare network model with the Relational Database Model.
(b) How is "Functional Dependency" implied in the relational tables?
(c) discuss the BCNF code along with its definition.

3. (a) elaborate the different Variable Data kinds ? discuss every in short.
(b) discuss the integrity Constraints ? Why it is important ?
(c) Write the statement to create trigger and discuss the role of trigger in PL/SQL programming.

4. (a) discuss 5 mouse and keyboard events with a small comment on every.
(b) What is the fundamental difference ranging from branching and looping statements ? discuss.
(c) classify and brief the kinds of errors which are encountered when fault are trapped.

5. (a) discuss ADO object model.
(b) discuss grid control for data retrievel.
(c) What is the impact of data environment for DBMS system ?

Earning:   Approval pending.