Computer Science: An Overview: Global Edition (12th Edition)

Published by Pearson Higher Education
ISBN 10: 1292061162
ISBN 13: 978-1-29206-116-0

Chapter 9 - Database Systems - Chapter Review Problems - Page 451: 10

Answer

See the explanation

Work Step by Step

The SELECT (σ) and PROJECT (π) operations are commutative only if the SELECT condition involves only attributes that appear in the projection list. In other words, if the selection criteria involve only attributes included in the projection, the order does not affect the outcome.
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.