Biju Patnaik University of Technology 2008-5th Sem B.Tech (B Tech) ,ester relational database management system . - Question Paper
BPUT(B Tech) ,5th semester relational database management system ques. paper. ToIaJ number ot printed pages - 7 g. Tech BOSE 3202
Fourth Semester Examination - 2008
RELATIONAL DATABASE MANAGEMENT SYSTEMS
Full Martts - 70
Tlrcve - 3 Hours
Ansn-rr Qu**$tton No 1 which is compulsory
and any five from the rest.
Thp figures in ihe ng fit'hand margin mdicate marks
2xM)
Dettne the following terms :
(a) Whai is the difference between a primary key and a candidate key ?
(b) 'Let R = (A. B, C, D) and functional dependencies (1) A > C. (2) AB * D. What is the closure of {A, B} ?
PXO.
(cl ivhat <#o yoo mtan by &#rpti fo*n ? 2 (d> Deftno supfir hey and1 Qtvo e*ampto to MJusiiare fhe super key (ejf Wha1 arc tn# two techniques to present deadlock ? (0 What do you moan by mulir vaJucd dependency ? (fl) Define and differentiate Iberween Natural] WL Join and Inner Join, 3 (h) What is meant by Concurrency ? [i) Mention the various categories of Data Model. 0) Deline: Entity Type, Entity Sal and Value Set. 5 p.m BCSE 3202 2 Contd. |
iaj What *s normalization of relation ? Whai is a kay attribute m a relation ? What is the difference' between 1* Normal Form, 2nd normal form and 3 normal form ? {b) Define entity, attnbule and relalronships as used m rotational databases. Describe purpose of E-R Model, Illustrate your answer with an example. 5 (a) Define the structure and properties of B Tree, Explain Ihow the B tree is used as a index structure. Construct a B tree of order 3 with following key value : 10. 2, 30, 20, 86, 4, 6, 3, 60, S4, 88, 33, 52; 91, 69, BCSE 3202 |
(b) Whal are the major components of the relational model ? What is simple relational database ? What are two models in which you can use SOL ? 5 4. (a) Explain difference between Implicit and Explicit locks. Give examples to support your answer. 5 {b) What is an object-oriented database ? IWL What is its advantages compared to relational database ? Explain some applications where an object-oriented database may be useful 5 5. (a) State Armstrong's axioms. Show that Armstrongs axioms are complete. 5 BCSE 3202 Contd. |
(b) Explain the difference between inner join and outer join. What are the restrictions on using outer join ? Give examples to support your answer, 5 6. (a) What does the term redundancy mean ? Discuss the implications of r edundancy in a relational database, 5 (b) Define (i) Primary key, and (is) Foreign key, Suppose relation FAC.D.Elihas functional dependencies: AB -> C D -> A AE B CD E BE D Find all the candidate keys of ft 5 BCSE 3202 5 p-T-- |
7. (aj Wftat us a dr&UtbuitrcJ database manage* mcni system 7 How is if, different to lhai of dtenl server database systems ? 5
(b) Consider ihe following tables 2
S R
|
|
Show the semantics and the output of the following query .
SELECT *
FROM St R
WHERE S.A = R*A AND S.0 s R.G ;
fc) Define "Data mining1'. What are ihe supports must available with DBMS to taciilitate dala mining ? 3
8.
I a) List ooit 1he six fundamental operators and
4 additional operators in relational algebra.
2.5
(to) Expfan the two conditions needed for the set d>fferer>ce operation (union opera-tion) to be valid. 2.5
(c) Construct a B+ tree of order 1 with folfowing keys, 1,9. 5t 3, 7,11,17,13, 15 f 2.5
(d) What is the use of outer join and list out the three types of outer join with the' notations used in relational algebra ?
2,5
BCSE 3202 7 -C
Attachment: |
Earning: Approval pending. |