Punjab University 2003 B.Tech RELATIONAL DATABASE MANAGEMENT SYSTEM - Question Paper

CS-305
RELATIONAL DATABASE MANAGEMENT SYSTEM
(B.Tech fifth Semester)
Time : three Hours Maximum Marks : 60
NOTE:- This paper consist of 3 parts. part A is compulsory. Do any 4 ques. from
part B and any 2 ques. from part C

Section-A Marks : 20

1(a) elaborate the major differences ranging from a file processing system and a DBMS ?
(b) discuss the difference ranging from Physical and Logical Data Independence.
(c) Wha tare the main functions of a data base administrator ?
(d) discuss the difference ranging from a weak and strong entity set.
(e) describe the concept of Aggegation with the help of example.
(f) define the difference ranging from Relation nad Relation scheme.
(g) elaborate the main advantages of Distributed database ?
(h) elaborate the different kinds of locks available to Control Concurrency ?
(i) What do you understand by Serializable Schedule ?
(j) Why are 3 kinds of data Decription needed?

Section-B Marks:5 every

2. discuss why four NF as a normal form more desirable than BCNF with the help of example.
3. discuss the term DML with the help of suitable example.
4. explain the Secuirty Model to give Authorization to different Authenticated Users.
5. elaborate triggers ? How can they help in bulding Robust Database?
6. explain different Data Recovery Techniques in brief.

Section-C Marks : 10 every

7. discuss Merge-Join Algrothim with the help of suitable example.
8. Consider the subsequent Relational Database:
Empolee (EMP_Name, Street, City)
Works(EMP_Name, Company_Name, Salary)
Company(Comapny_Name, City)
Manages (EMP_Name,Manager_Name)
For every of the subsequent quires, provide an expression in the Relational Algebra, Tuple Realtional Calculus.
(a) obtain the names of all Employees who work for Satyam.
(b) obtain the names and cities of Residence who work for Satyam.
(c) obtain the names of all Employees who live in the identical city as the company for which they work.
(d) obtain the names of all Employees who do not work for Satyam.
(e) obtain the names of all Employees who live in the identical city and on the identical street as do their Managers.
9. Writ short note on the following:
(a) four GL's forms Management and Report authors.
(b) Object Oriented Databases.

Earning:   Approval pending.