Recent questions tagged databases

0 votes
1 answer
61
In SQL the statement $\text{select * from R, S}$ is equivalent to$\text{select * from R natural join S}$$\text{select * from R cross join S}$$\text{select * from R outer ...
0 votes
1 answer
63
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$$T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$$T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
0 votes
0 answers
68
0 votes
0 answers
69
If in a relationship an entity totally participates, and if it contains a foreign key then the foreign key can not be null in relation table format?
0 votes
0 answers
71
0 votes
1 answer
72
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?
0 votes
0 answers
73
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct.Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagra...