Recent questions tagged databases

0 votes
0 answers
1651
What is the disadvantage of avl tree over b tree ??
3 votes
1 answer
1652
0 votes
0 answers
1653
R(ABCDE) { A,BC,CD} are candidate key of relation R after 1 NF design which one is possible multi valued attributes before 1 NF design ???
2 votes
1 answer
1654
How to remove extraneous attributes ??Que - find the minimal cover of the functional dependency setA->BCDEF BC->ADEF B->F D->E explain whlole procedure please
2 votes
2 answers
1657
1. How many super key is possible if (a,bc,cd) is candidate key and R(ABCDEF)#DOUBTWhen we use veen digram why we are taking only intersections part only ??? Need help pl...
2 votes
0 answers
1658
1 votes
1 answer
1659
2 votes
2 answers
1660
4 votes
1 answer
1661
3 votes
1 answer
1662
Which one is the more suitable answer for the following question, equijoin or natural join?
1 votes
2 answers
1663
Database file consists 1250 records.Block can hold either 3 record or (10 key,11 pointer ) The max number of level of index required for dense B+ tree index for daatabase...
0 votes
1 answer
1664
What is the correct interpretion of this query
0 votes
2 answers
1666
Assume COFFEE is the relation,find number of tuple1) 62) 43) 54) 3
4 votes
1 answer
1667
What is difference between attributes set of cross product and attributes set of joine ???
2 votes
0 answers
1669
2 votes
0 answers
1670
1 votes
1 answer
1672
What is basic difference between mandatory attributes and multivalued attributes???
1 votes
2 answers
1673
1- R(ABCD) FD'S ARE {AB->C ,C->D,D->EA ,DE->F,EF->B}2-R(ABCD) FDS ARE { A->BC, CD->E, B->D,E-A}3- R(ABCD) {AB- CD,C->B,D->C} Find the candidate key ??? For above questi...
2 votes
1 answer
1674
Que- R(ABCD) and fds are { A->B ,B->C,C->A} then number of candidate key is........?Explain please
1 votes
1 answer
1675
1 votes
2 answers
1676
2 votes
1 answer
1677
0 votes
0 answers
1678
Consider the following schedule:S: r1(A), r3(D), w1(B), r2(B), r4(B), w2(C), r5(C), w4(E), r5(E), w5(B)The number of serial schedules which are view equal to schedule S ?...
2 votes
0 answers
1679
1 votes
2 answers
1680