An ALLBASE/SQL database is defined both logically and physically.
Logically, an ALLBASE/SQL database is one or more tables or views
with the same owner.
This chapter will give guidelines
on how to design the
logical structure of a relational database
and to use ALLBASE/SQL table, view, and
index definition features to meet the needs of
users and applications.
The logical design process lets you create
efficient databases so that your
applications will perform smoothly and be
easy to maintain and support.
The process consists of several distinct steps:
Identifying the data for tables
Designing hash structures
Designing integrity constraints
Defining the DBEnvironment scope
The following
sections describe each of these steps using the sample
DBEnvironment PartsDBE as an illustration.