Chapter 4. Building an Oracle9i Database

This chapter builds a series of tables, indexes, sequence generators, and constraints, a sample database that will be used in examples throughout the remainder of this book. You will learn how to design a relational application, load data into it, and then build the forms and reports that will manipulate and report on the data.

This chapter teaches you the following:

• How to build a relational database based on business requirements

• How to use many of the techniques learned in Chapter 2

• How to build the book sample database used in the remaining chapters