Question

Consider the following table defined using the CREATE TABLE statement below: CREATE TABLE R (col1 INT, col2 INT); Consider the following two relational algebra plans called P1 and P2, that are executed against the schema given below. Come up with data (R table should have at least 1 row of data) that will give different results for the 2 plans. Also show the result of the plans. P1: U P2: ? $\sigma_{col1=1}$ $\sigma_{col2=6}$ $\sigma_{col1=1}$ $\sigma_{col2=6}$ R R R R

          Consider the following table defined using the CREATE TABLE statement below:
CREATE TABLE R (col1 INT, col2 INT);
Consider the following two relational algebra plans called P1 and P2, that are executed against the
schema given below. Come up with data (R table should have at least 1 row of data) that will give
different results for the 2 plans. Also show the result of the plans.
P1:
U
P2:
?
$\sigma_{col1=1}$ $\sigma_{col2=6}$
$\sigma_{col1=1}$ $\sigma_{col2=6}$ 
R
R
R
R

Consider the following table defined using the CREATE TABLE statement below:
CREATE TABLE R (col1 INT, col2 INT);
Consider the following two relational algebra plans called P1 and P2, that are executed against the
schema given below. Come up with data (R table should have at least 1 row of data) that will give
different results for the 2 plans. Also show the result of the plans.
P1:
U
P2:
?
σcol1=1 σcol2=6
σcol1=1 σcol2=6
R
R
R
R

Added by Paula F.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Sri K

06/11/2023

Step 1

Step 1: The table R is defined with two columns, col1 and col2, both of type INT. Show more…

Show all steps

Thanks for your feedback!

Consider the following table defined using the CREATE TABLE statement below: CREATE TABLE R (col1 INT, col2 INT); Consider the following two relational algebra plans called P1 and P2, that are executed against the schema given below. Come up with data (R table should have at least 1 row of data) that will give different results for the 2 plans. Also show the result of the plans. P1: σ(col1=1 ∧ col2=6)(R) P2: R Data for R table: R: col1 | col2 -----|----- 1 | 6 Result of P1: col1 | col2 -----|----- 1 | 6 Result of P2: col1 | col2 -----|----- 1 | 6