Database Design



Definition

Database design is the design subactivity consisting of the cohesive collection of all tasks involving the design of one or more related databases (or datastores).

Goals

The goals of database design are to:

Objectives

To meet this goal, the objectives of database design are to:

Examples

Examples of database design include:

Preconditions

Databse design may typically begin when the following preconditions hold:

Completion Criteria

Database design is typically complete when the following postconditions hold:

Tasks

Database design typically involves the following producers performing the following design tasks in an iterative, incremental, and parallel manner:

Work Products

Database design results in the production of the following work products:

Guidelines