Consider the following relational schemas: And the instances (snapshots) of…
Consider the following relational schemas:
And the instances (snapshots) of the above schemas:
Consider the following relational algebra query is executed on the above instance:
The number of rows return by above query is ________.
This query finds the names of sailors who have reserved a red boat.
Answer: 3 — projection on bid with selection criteria as red gives 2 output this 2 output is joind on table reserves projecting the sid from the above table and applying…
Attempted by 3 students.
Show answer & explanation
Correct answer: 3
projection on bid with selection criteria as red gives 2 output
this 2 output is joind on table reserves
projecting the sid from the above table and applying nautral join on sailors we get three names as
A video solution is available for this question — log in and enroll to watch it.