The Relational Model: It's All Tables
Codd's very first rule says that all information in a relational database is represented by values in tables. In a relational system, tables have (horizontal) rows and (vertical) columns (see Figure 1.1). All data is represented in table format—there's no other way to see the information in the database.
Figure 1.1. The publishers Table
A note on terminology: Because table, row, and column are the common terms used in commercial relational database management systems, they're the ones we'll use in this book. The parallel relational model terms are relation, tuple, and attribute. The related general data processing ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.
