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>


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

Original text of this message