Question: Using the relation table R as shown: A B C a 1 b 1 c 1 a 2 b 2 c 2 a 3 b
Using the relation table R as shown:
| A | B | C |
| a1 | b1 | c1 |
| a2 | b2 | c2 |
| a3 | b3 | c2 |
| a3 | b3 | c3 |
What is the result from the following SQL statement?
SELECT C FROM R WHERE B = 'b3'
| a. |
| ||||||
| b. |
| ||||||
| c. |
| ||||||
| d. |
|
Using the relation table R as shown:
| A | B | C |
| a1 | b1 | c1 |
| a2 | b2 | c2 |
| a3 | b3 | c2 |
| a3 | b3 | c3 |
What is the result from the following relational algebra expression? That is, the Project Operation is applied to table R on column C.
That is, the Project Operation is applied to table R on column C.
| a. |
| ||||||
| b. |
| ||||||
| c. |
| ||||||
| d. |
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
