Chapter 9 SQL Data Types
Not everything that counts can be counted, and not everything that can be counted counts.
Welcome to the first of three chapters in this book about database design. If you’ve followed along faithfully until now, well done. Several chapters were needed to cover the
SELECT statement in detail, so that we could gain an appreciation for how tabular data is extracted from the database, filtered, summarized, presented, and sequenced. Now it’s time to turn our attention to the challenges of creating database tables.
Creating tables is straightforward, with only a few tricky aspects to watch out for. These are encountered primarily when deciding how tables should be related to each other, ...