Pandit Ravishankar Shukla University 2009 B.Sc Computer Science Pandit ravishankar university's of (Software) - Question Paper

B.Sc. (Part III) EXAMINATION, 2009
COMPUTER SCIENCE
Paper Second
(DBMS and RDBMS)

Time : 3 Hours] [ Maximum Marks : 50

Note : Attempt any 2 parts from every ques.. All ques. carry equal marks.

1. (a) discuss different data modeling in database management system.
(b) discuss different database languages with commands in Database Management System.
(c) explain the difference ranging from weak and strong entity sets.

2. (a) Mention the difference ranging from Relational Algebra and Relational calculus.
(b) elaborate pitfalls in Relational Database Design ? discuss with suitable example.
(c) discuss 3NF, BCNF with example.

3. (a) discuss ORDER BY and GROUP function with suitable examples.
(b) discuss different commands with example for changing password and granting roles and privilege.
(c) Write a PL/SQL statements for copying record of 1 database file to a different database file with the help of variable.

4. (a) Why VB is known as Event driven programming language ?
(b) Write a program for using Picture Control with reference to rocket launching statements.
(c) discuss sequential and Random access file organization in visual Basic.

5. (a) discuss the difference ranging from DAO, RDO and ADO.
(b) Write step by step process for setting DATA Environment and Data Report in Visual Basic.
(c) State the difference ranging from MDI and SDI in visual Basic. provide suitable example.

Earning:   Approval pending.