Database Design
As you can tell by now, the relational model is completely centered around tables. All data in a database is stored in tables, and all queries receive their results in tables. Therefore, when you’re thinking about how to organize your data, it’s important to think about how to group your data within tables. Here are some important rules that apply:
All data must be returned by the database in a tabular format.
Each field must contain a single value.
For the purposes of data integrity, every row must contain a value (or group of values) that uniquely identifies that row.
A relationship between two tables is represented by part or all of the data in a column. In other words, the column data that expresses a relationship must appear ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access