A question I once found on a test was worded as such:
Report the book information for the book with ISBN=43221
The relational schema for a book is depicted below:
πISBN, title, type, NumPages, edition, sequel, name(σISBN=43221(Book))
This is essentially the equivalent of
SELECT * FROM Book WHERE ISBN=43221.
I wrote out all the attributes in the Projection statement on the test, but I had the feeling there was a quicker way to do it.
Is there a shortcut way of displaying all the information of one tuple in Relational Algebra, or must all attributes be written out in the Project statement?