Relational database theory is based on set theory.1 When we query a database we are essentially formulating a question to retrieve a subset containing the information we require. There are two approaches for retrieving a subset of data. Relational algebra is a description of the operations to perform on the data (in the body of the book we called this the process approach). Relational calculus describes conditions that the retrieved data must satisfy (we referred to this as the outcome approach). In this appendix we introduce the formal notation to formulate queries using ...
© Clare Churcher 2016
Clare Churcher, Beginning SQL Queries, 10.1007/978-1-4842-1955-3_14
2. Relational Notation
Clare Churcher1
(1)Studio B Productions, Great Neck, New York, USA
Get Beginning SQL Queries: From Novice to Professional, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
