ASA SQL User's Guide
  Designing Your Database

The design process

There are five major steps in the design process.

• Step 1: Identify entities and relationships.

• Step 2: Identify the required data.

• Step 3: Normalize the data.

• Step 4: Resolve the relationships.

• Step 5: Verify the design.

For more information about implementing the database design, see Working with Database Objects.

Step 1:  Identify entities and relationships
Entity and relationship example
Step 2:  Identify the required data
Step 3:  Normalize the data
Step 4:  Resolve the relationships
Step 5:  Verify the design