Microsoft® SQL Server™ 2005: Applied Techniques Step by Step

Gathering Requirements

Given that scenario, you begin to design a draft of the database schema. Of course, in the real world, you will begin by creating a list of requirements, some UML (Unified Modeling Language) schemas, and other items before designing the database, but let’s compress that process for the sake of simplicity.

Preliminary Requirements

Most likely, the schema includes the items shown in Table 13-1. It makes sense to try to design the application to be reusable for other notification scenarios not related to birding. Therefore, you will name the common elements with generic names, allowing for their reuse without having to rewrite shared items.

Table 13-1. Birding Application Schema Elements

Item	Name
List of regions	Regions
List ...