|
Tutorials
Database Design Application
Design
|
||||||||
|
|
||||||||
|
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 | ||||
|
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
| ||||
|
|
||||