12. Designing Tables

This chapter explains items that should be examined during table design.

This chapter contains the following sections:

Organization of this chapter

12.1 Items to be examined during table design

12.2 Normalizing a table

12.3 Table row partitioning

12.4 Table matrix partitioning

12.5 Defining a trigger

12.6 Creating a view table

12.7 Specifying the FIX attribute

12.8 Specifying a primary key

12.9 Specifying a cluster key

12.10 Specifying the suppress option

12.11 Specifying the no-split option

12.12 Specifying a binary data column

12.13 Specifying the WITHOUT ROLLBACK option

12.14 Specifying the falsification prevention facility

12.15 Table containing a repetition column

12.16 Table containing an abstract data type

12.17 Shared tables

12.18 Referential constraints

12.19 Check constraints