PTU B.Tech Automation Robotics ECE-EIE 6th Semester May 2019 71125 RELATIONAL DATA BASE MANAGEMENT SYSTEM Question Papers

PTU Punjab Technical University B-Tech May 2019 Question Papers 6th Semester Automation Robotics ECE-EIE

Roll No.
Total No. of Pages : 02
Total No. of Questions : 09
B.Tech.(Automation & Robotics) (DE-I 2011 & Onward)/
(ECE)/(ETE) (E-I 2011 Onwards) (Sem.?6)
RELATIONAL DATA BASE MANAGEMENT SYSTEM
Subject Code : BTEC-901
M.Code : 71125
Time : 3 Hrs. Max. Marks : 60
INSTRUCTION TO CANDIDATES :
1.
SECTION-A is COMPULSORY consisting of TEN questions carrying T WO marks
each.
2.
SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
3.
SECTION-C contains T HREE questions carrying T EN marks each and students
have to attempt any T WO questions.

SECTION-A
Q1. Answer briefly :

a) Write advantages of DBMS.

b) Write in brief about DBMS Layers.

c) What is clustered index organization?

d) Define Entity, Attributes, Entity set, relationship.

e) Differentiate between Cartesian product and natural join operations used in relational
algebra.

f) Differentiate between SQL commands DROP TABLE and DROP VIEW.

g) What is the need of the normalization? Explain the first three steps involved in the
normalization.

h) Explain the classification of functional dependency

i) Why is concurrency control needed?

j) Explain in brief about Encryption and Digital Signatures.
1 | M C o d e 7 1 1 2 5

( S 2 ) - 2 2 7 2

SECTION-B
Q2. Differentiate between File Systems and DBMS.

Q3. Explain the following terms in brief.

a) Hashing

b) B-trees

Q4. Explain in detail about Hierarchical Data Model.

Q5. Write a detailed note on Relational Algebra.
Q6. Explain in detail about Basic query Optimization Strategies.

SECTION C
Q7. a) Define BCNF. How does BCNF differ from 3NF? Explain with example.

b) What is meant by multivalued dependency? Explain with example.

Q8. a) Explain ACID properties of transaction management

b) Explain in detail about deadlock handling.
Q9. Explain in detail about following terms :

a) Role Based Security

b) Bell-la-Padula Model



NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any
page of Answer Sheet will lead to UMC against the Student.

2 | M C o d e 7 1 1 2 5

( S 2 ) - 2 2 7 2

This post was last modified on 04 November 2019