Ch 2. Looking at Data [ Up and Running with ALLBASE/SQL ] MPE/iX 5.0 Documentation
Up and Running with ALLBASE/SQL
Chapter 2 Looking at Data
This chapter presents the basic steps in data analysis and database
design:
* Understanding the process.
* Distinguishing entities and attributes.
* Identifying relationships between entities.
* Locating distinguishing key items.
* Creating the table design.
* Defining indexes.
* Defining views.
* Estimating table and index size.
* Designing applications.
These terms are explained as each step is discussed in the following
sections. If you already have a table design in mind and you want to set
it up at once, skip this chapter; come back later if you wish. But if
you don't know what data to put into which tables, then read on!
MPE/iX 5.0 Documentation