Re: Tutorial on Database design: where ???
From: Tobin Harris <comedyharris_at_hotmail.com>
Date: Fri, 29 Aug 2003 09:35:56 +0100
Message-ID: <bin39d$as225$1_at_ID-135366.news.uni-berlin.de>
Date: Fri, 29 Aug 2003 09:35:56 +0100
Message-ID: <bin39d$as225$1_at_ID-135366.news.uni-berlin.de>
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.com> wrote in message
news:6fjskvkfuntb9n9ho9vb4rjhp09pv5jcsc_at_4ax.com...
> Dear Friends,
> anyone knows where can i find any tutorial (downloadable) on Database
> design ???
> Thanks in advance
> Stefano
>
Received on Fri Aug 29 2003 - 10:35:56 CEST