Register
Webpage for Databases:

Recent questions tagged databases

0 votes
1 answer
2221
Relation between tables in different databases
Is there any way to establish a Relation between tables in different databases??
Is there any way to establish a Relation between tables in different databases??
User Avatar
0 votes
1 answer
2222
What is the difference between database model and database schema?
What is the difference between database model and database schema? Any useful link please....
What is the difference between database model and database schema? Any useful link please....
User Avatar
5 votes
1 answer
2224
decomposition
For givem relation R(A,B,C,D,E) F:{B ->D,CD ->E,E->A,A->BC} Is it possible 2 decompose R into two relations R1and R2 such that Decomposition is lossless-join ,dependency-preserving and in BCNF normal form ??
For givem relation R(A,B,C,D,E)F:{B ->D,CD ->E,E->A,A->BC}Is it possible 2 decompose R into two relations R1and R2 such thatDecomposition is lossless-join ,dependency-pr...
User Avatar
3 votes
2 answers
2226
foreign key constraint
What is on delete no action,on delete cascade, on delete set null action?? explain through some eg??
What is on delete no action,on delete cascade, on delete set null action??explain through some eg??
User Avatar
2 votes
1 answer
2230
Doubt
Can someone please explain this question? I am not able to understand it
Can someone please explain this question? I am not able to understand it
User Avatar
5 votes
3 answers
2232
Number of minimal candidate keys
A relation R(A,B,C,D,E,F) holds following FDs $AB\rightarrow C$ $C\rightarrow D$ $D\rightarrow EA$ $E\rightarrow F$ $F\rightarrow B$ The number of minimal candidate keys of R are _______.
A relation R(A,B,C,D,E,F) holds following FDs$AB\rightarrow C$$C\rightarrow D$$D\rightarrow EA$$E\rightarrow F$$F\rightarrow B$The number of minimal candidate keys of R a...
User Avatar
2 votes
2 answers
2233
Doubt
R(A , b, c) with n tuples, S(A , D, E). How many max tuples in R natural join S? {A is key for both} $\min (m,n)$ $\max(m,n)$ $m*n$ $m+n$
R(A , b, c) with n tuples, S(A , D, E). How many max tuples in R natural join S? {A is key for both}$\min (m,n)$$\max(m,n)$$m*n$$m+n$
User Avatar
11 votes
2 answers
2234
Doubt
for all the above questions answer the following : a ) how many minimum relation tables are required which satisfy 1NF b) how many minimum relation tables are required which satisfy 3NF c) how many minimum relation tables are required which satisfy BCNF d) minimum tables required Note: please provide detailed answer
for all the above questions answer the following :a ) how many minimum relation tables are required which satisfy 1NFb) how many minimum relation tables are required whic...
User Avatar
3 votes
2 answers
2237
Concurrency Strict Schedule
Consider the following database schedule with two transactions T1T1 and T2T2. S=r2(X);r1(X);r2(Y);w1(X);r1(Y);a1;a2 where a1 and a2 stands for abort. Is It a strict schedule? Please explain why or why not?
Consider the following database schedule with two transactions T1T1 and T2T2.S=r2(X);r1(X);r2(Y);w1(X);r1(Y);a1;a2 where a1 and a2 stands for abort. Is It a strict sched...
User Avatar
5 votes
1 answer
2240
#b-tree #DBMS
Let the order of B-tree is 32 and the B-tree is 63% full. What will be the number of <key,data pointer> entries the 2 level B tree holds?
Let the order of B-tree is 32 and the B-tree is 63% full. What will be the number of <key,data pointer entries the 2 level B tree holds?
User Avatar
6 votes
1 answer
2242
Basic doubt in B+ Tree Indexing
Q : One basic doubt that is coming to my mind is whether number of splits in the process of insertion in B+ Tree indexing going to change if we consider left biasing and right biasing approach.Plz present any example to show if possible..
Q : One basic doubt that is coming to my mind is whether number of splits in the process of insertion in B+ Tree indexing going to change if we consider left biasing and ...
User Avatar
6 votes
1 answer
2249
MadeEasy Test Series: Databases - Er Diagram
Consider the following ER diagram: The minimum number of tables needed to represent ER-diagram are _____ .
Consider the following ER diagram:The minimum number of tables needed to represent ER-diagram are _____ .
User Avatar
Page: