Home

Tutorials

Introduction

Database Design

Application Design  
  If these tutorials have proven useful, please consider donating to the maintainence of this site.  Click here to find out why.

What follows are some topics important to proper database design.  Following these are several examples of database design problems and their solutions.

Topics:

Why Normalization?
The Normal Forms (in development)
Unique Indexes and Surrogate Keys

The Hernandez Process In A Nutshell

ERMaster.ppt (ER Diagram template for PowerPoint)

Examples:


**Note: The PROCESS is the important thing here.  It may be that I have made a mistake in the actual modeling.  That will come out in the discussions with the customer and the prototyping.  But pay attention to the process that went into the examples. **
Class Information Database (stores information about students in a college class)
Cater-It Database (small catering business)
GSA Database (Gender Non-specific Scouts of America)
Scrip Database (a high school fund-raising program )

Consolidated Widgets (stores information for the Widget Trade Show)

Design Links:

Library of Free Data Models
Here are some useful 'Kick-Start' Data Models
Also, check out these sites:
http://www.datamodel.org/NormalizationRules.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;q209534
http://support.microsoft.com/default.aspx?scid=kb;EN-US;164172
http://support.microsoft.com/default.aspx?scid=KB;en-us;q234208