Verifying Relational Algebra Question

Question

I think it should be option a)

All query $1,3,4$ are equivalent but $2$ is not equivalent.

Query $2$ should be 

$\prod \text{Room no,hotel no,type,price}(\sigma \text{type='single' } \wedge \text{price=200 })$

Comments

Why? query 2 is also equivalent. It will print all rows of data with condition given.

Answer 1

When you don't use project and do only select, by default all the columns are returned, thus making Query 2 same as Query 1. 

Eg:

Comments

can u refer any link for that ? @goxul

---

@arvin Sure, here you go. http://infolab.stanford.edu/~ullman/fcdb/aut07/slides/ra.pdf

From Jeffrey Ullman's DBMS slides.

You can find all of them here: http://infolab.stanford.edu/~ullman/fcdb/aut07/

---

thanks bro :)