Register
Webpage for Databases:

Recent questions tagged databases

33 votes
4 answers
2161
GATE CSE 1989 | Question: 12a
The below figure shows a $B^+$ tree where only key values are indicated in the records. Each block can hold upto three records. A record with a key value $34$ is inserted into the $B^+$ tree. Obtain the modified $B^+$ tree after insertion.
The below figure shows a $B^+$ tree where only key values are indicated in the records. Each block can hold upto three records. A record with a key value $34$ is inserted...
User Avatar
2 votes
1 answer
2162
Lossy join decomposition
User Avatar
0 votes
2 answers
2163
Transactions
User Avatar
3 votes
3 answers
2170
B-Tree: Counting number of keys.
Let T be a B-tree of order m and height h. if n is the number of key elements in T then the maximum value of n is ? I'm getting $m^{h+1}-1$, Am I correct?
Let T be a B-tree of order m and height h. if n is the number of key elements in T then the maximum value of n is ? I'm getting $m^{h+1}-1$, Am I correct?
User Avatar
0 votes
1 answer
2172
Database
Given R (ABCDE) A-->BC,CD->E B->D E->A CONVERT GIVEN INTO 1NF 2NF 3NF AND THEN BCNF PLEASE VERIFY :)
Given R (ABCDE)A >BC,CD->E B->D E->ACONVERT GIVEN INTO 1NF 2NF 3NF AND THEN BCNF PLEASE VERIFY :)
User Avatar
0 votes
1 answer
2173
Database
Given R (ABCDE) FDS ARE A-->BC,C-->DE, D-->E R1(ABCD) R2(DE) FIND WHETHER ITS DECOMPOSITION IS VALID OR NOT and Fd preserving too
Given R (ABCDE)FDS ARE A >BC,C >DE, D >ER1(ABCD) R2(DE)FIND WHETHER ITS DECOMPOSITION IS VALID OR NOT and Fd preserving too
User Avatar
0 votes
2 answers
2175
Ace Test Series: Databases - Er Diagram
User Avatar
1 votes
2 answers
2176
Ace Test Series: Databases - B Tree
User Avatar
0 votes
2 answers
2177
Find serilaiability of given schedule
i) Is this schedule conflict serializable? ii)is this scheule view serializable? ii) Is this schedule serializable??
i) Is this schedule conflict serializable?ii)is this scheule view serializable?ii) Is this schedule serializable??
User Avatar
0 votes
1 answer
2178
Find the serializability of given schedule
i) Is this schedule conflict serializable? ii)is this scheule view serializable? ii) Is this schedule serializable?? HOW TO SOLVE THIS PROBLEM?
i) Is this schedule conflict serializable?ii)is this scheule view serializable?ii) Is this schedule serializable??HOW TO SOLVE THIS PROBLEM?
User Avatar
11 votes
1 answer
2179
GATE CSE 1989 | Question: 4-xiv
For secondary key processing which of the following file organizations is preferred? Give a one line justification: Indexed sequential file organization. Two-way linked list. Inverted file organization. Sequential file organization.
For secondary key processing which of the following file organizations is preferred? Give a one line justification:Indexed sequential file organization.Two-way linked lis...
User Avatar
0 votes
0 answers
2182
SQL HAVING Clause
Can Anyone Explain how Query 28 works with example.
Can Anyone Explain how Query 28 works with example.
User Avatar
1 votes
2 answers
2186
ER to Table Conversion
Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?
Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?
User Avatar
0 votes
0 answers
2187
doubt
can derived attribute be derived from more than one entitiy or from different entity????
can derived attribute be derived from more than one entitiy or from different entity????
User Avatar
Page: