5.1 Database design procedure

The following figure shows the procedure for designing a database.

Figure 5‒1: Database design procedure

#1

For details about the procedure, see 5.2 Designing a table.

#2

For details about the procedure, see the following sections:

• 5.3 Designing a B-tree index

• 5.4 Designing a text index

• 5.5 Designing a range index

#3

For details about the procedure, see 5.6 Designing a data DB area.

#4

For details about the procedure, see 5.7 Designing a work table DB area.

#5

For details about the procedure, see the following sections:

• 5.8 Estimating the size of the data DB area

• 5.9 Estimating the size of the work table DB area

• 5.10 Estimating the size of the master directory DB area

• 5.11 Estimating the size of the dictionary DB area

• 5.12 Estimating the size of the system-table DB area

To Page Top