13. Designing Tables

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

This chapter contains the following sections:

Organization of this chapter
13.1 Items to be examined during table design
13.2 Normalizing a table
13.3 Table row partitioning
13.4 Table matrix partitioning
13.5 Defining a trigger
13.6 Creating a view table
13.7 Specifying the FIX attribute
13.8 Specifying a primary key
13.9 Specifying a cluster key
13.10 Specifying the suppress option
13.11 Specifying the no-split option
13.12 Specifying a binary data column
13.13 Specifying the WITHOUT ROLLBACK option
13.14 Specifying the falsification prevention facility
13.15 Table containing a repetition column
13.16 Table containing an abstract data type
13.17 Shared tables
13.18 Referential constraints
13.19 Check constraints