Consider the following schema:
The primary key fields are underlined, and the domain of each field is listed after the field name. Assume there are no NULL values in any column of any relation and every relation has at least one tuple. $\textsf{“Sid”}$ of Reserves is foreign key to $\textsf{Sailors.sid}.$
Assume that there is at least one sailor who has reserved a boat with bid $104$ in the reserves table.
Consider the following query :
SELECT S.sid
FROM Sailors S, Reserves R
WHERE S.rating = 10 OR R.bid = 104
What is the output of the above query?
- All sids of sailors who have a rating of $10$ AND have reserved boat $104.$
- All sids of sailors who have a rating of $10 $ OR have reserved boat $104.$
- All sids of sailor table
- Empty set.
