BPUT Question Answer

I am doing BBA (Bachelor of Business Administration) course from BPUT (Biju Patnaik University of Technology) and will be giving 3rd semester exam so can you please provide me previous years' solved question papers of the semester of BPUT (Biju Patnaik University of Technology)?

Can you provide me the previous year B. Tech Database Management Systems 4th semester Question Paper of Biju Patnaik University of Technology (BPUT), Rourkela?

[pawan]

The previous year B. Tech Database Management Systems 4th semester Question Paper of Biju Patnaik University of Technology (BPUT), Rourkela is as follows:

Q1 Answer the following questions: (2 x 10)

a) Compare data definition and data manipulation language with examples.

b) The values of the attribute describes a particular_____________

c) How Relational Calculus is different from Relational Algebra?

d) Tree structures are used to store data in
(A) Network model. (B) Relational model.
(C) Hierarchical model. (D) File based system.

e) What is the role of the disk space manager?

f) Discuss the Armstrongs axioms for Transitivity functional dependencies

g) Define entity integrity and referential integrity.

h) Is two relational operator combines with the join operation? if so mention them.
i) Why is optimization required?
j) Define normalization


Q2 a) Discuss three level database architecture and its users (5)
b) What is Data Integrity? Discuss the different kinds of data integrity. Then discuss the importance of it.


Q3 a) Discuss the different steps to design the E-R diagram (5)
b) Define physical and logical data independence through three layer architecture of DBMS.


Q4 Consider the relation R(A, B, C, D, E) with the set of function dependencies
F={A, B→ C, D→ E, A→ D}
(i) Is AB a candidate Key? Justify. (2)
(ii) Giving reasons find out whether R is in 3NF or BCNF. (4)
(iii) Consider the decomposition of R into R1 (A,B,C) and R2 (A,D,E). Is the decomposition lossless and dependency preserving? Justify.

B. Tech Database Management Systems 4th semester Question Paper BPUT, Rourkela