Databases
Visual Representation
Collected by Laura Farinetti — Lecture Notes
Query languages (basic)
visualizes that self-join requires the duplication of the same tables
| Symbol | Concept |
|---|---|
| arrows | join among rows |
How a self-join is processed in SQL
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".
A notional machine is a pedagogic device to assist the understanding of some aspect of programs or programming. To something along the lines of A notional machine is a pedagogical tool designed to support the understanding of programs, programming, and other aspects of computing such as databases.
