Punjab Technical University 2007-5th Sem B.E Computer Science DATABASE MANAGEMENT SYSTEM (CS - 305) (-2k7) - Question Paper

Paper ID [CS305]

B.Tech (Semester - 5th)

DATABASE MANAGEMENT SYSTEM (CS - 305)

Time : 03 Hours
Maximum Marks : 60

Instructions to Candidates :
1) part - A is Compulsory
2) Attempt any 4 ques. from part - B
3) Attempt any 2 ques. from part - C

part - A
(10 x two = 20)

Q1)

a) What do you understand by the term data redundancy ?

b) What is the significance of foreign key ?

c) What is the usage of Unified Modelling Language (UML) ?

d) What is the difference ranging from a procedural and non-procedural language ?

e) What is relational algebra ?

f) What is a trigger ?

g) elaborate multivalued dependencies ?

h) What do you mean by granularity of data items ?

i) What is statistical database security ?

j) What is data independence ?


part - B

Q2) List 5 significant differences ranging from a file processing system and a DBMS.

Q3) elaborate the major functions of a Database Administrator ?

Q4) elaborate the desirable properties of transactions in a database ?

Q5) elaborate locking techniques for concurency control ? discuss.

Q6) define the usefulness of granting privileges to users.


part - C
(2 x 10 = 20)

Q7)
(a) What do you mean by relationships ? discuss various kind of relationships.
(b) What is an ER diagram ? Construct an ER diagram for a hospital with a set of patients and a set of doctors. Associate with every patient a log of the different tests and exams conducted.

Q8) Consider the subsequent relational database and provide an expression in relational algebra to express every of the subsequent queries :
Employee (person-name, street, city)
Works (person-name, company-name, salary)
Company (company-name, city)
Managers (person-name, manager-name)

(a) obtain the names of all employees who work for 1st Bank Corporation.
(b) obtain the names and cities of residences of all employees who work for 1st Bank Corporation.
(c) obtain the names of all employees who do not work for 1st Bank Corporation.
(d) obtain the names of all employees who earn more than $10000 per annum.
(e) obtain the names of all employees who earn more than every employee of Small Bank Corporation.

Q9) Write short notes on the subsequent :
(a) Serializability of schedules.
(b) Shadow Paging
(c) Granting of privileges.

Earning:   Approval pending.