Boolean operators in SELECT statements as a diagram

Discipline

Databases

Form

Visual Representation

Attribution — Origin / Source

Collected by Laura Farinetti — Hoffer, J. A., Topi, H., & Ramesh, V. (2014). Essentials of Database Management. Prentice Hall Press.

Topic

Query languages (basic)

Domain

Within-Database

Conceptual Advantage

Visualizes the order in which the boolean operators are processed inside a WHERE clause

Mapping

SymbolConcept
set tables
boxes processing steps

Draws Attention To

Multiple Boolean operators inside a WHERE clause

Details

Images

Comments or Feedback?

Do you have feedback on this notional machine? Did you find a mistake, or do you have a request for improvement? You can create an Issue on GitHub, where the description is hosted. This way we can see your feedback and address it.

For this, you need a GitHub account. Then follow this link to see the source file of this page. In there, click the ... left of the highlighted line, then pick "Reference in a new issue".

Create an Issue on GitHub