Home > Products > UltraDev > Support > Building Common Applications
Dreamweaver UltraDev Icon Macromedia Dreamweaver UltraDev Support Center - Building Common Applications
Arrow Aircraft 1: Database design

This article describes the database-design phase of a Web application commissioned by a fictional company called Arrow Aircraft Services, a firm that manages a small fleet of privately owned business jets. Database design is the first step in building any database-driven Web site.

The article is the first in a series of a case study describing the process of building Arrow Aircraft's Web application. Visit the Building Common Applications page to see the other articles in this series.

Here are the topics covered in this article:

Studying Arrow Aircraft's business rules and policies
Studying Arrow Aircraft's feature request
What questions will users ask the database?
Choosing the tables that belong in the database
Choosing the columns in each table
Defining relationships between the tables
Creating the database

27 March 2001

database design, planning, Arrow Aircraft, relational, table, column, key, primary key, foreign key, one-to-many, many-to-many, e-r diagram