The process I was taught was roughly this:
- Get your requirements in the form of interview notes, existing
documents/forms/systems etc
- Build a top down conceptual data model (defining entities based on
understanding of the problem)
- Build a bottom up conceptual data model (by normalising attribute lists)
- Make sure these tally, and modify design as necessary
- Build a logical data model
Ok, this may not mean alot, but you could research the individual steps. You
may find good resources if you search google for things like:
- Normalisation Tutorial (or US normalization tutorial)
- Entity Relationship Diagram
- Top Down Data Analysis
- Bottum Up Data Analysis
Hope this is *some* help! Basically, normalisation is fairly key (excuse the
pun), so I would start with this.
Tobes
"Stefano" <delfo (AT) nospam_tech-center (DOT) com> wrote
Quote:
Dear Friends,
anyone knows where can i find any tutorial (downloadable) on Database
design ???
Thanks in advance
Stefano |