|
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 |
|
 |
9772 |
 |
|
|
|
