[AccessD] normalization question

Susan,

Those (FK's) I already know about I add as I get to them.  Those I don't
know about I have to go back and add later.  It's all part of the
iterative process.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com] 
Sent: Monday 2003 Mar 10 13:59
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] normalization question

I agree with your Charles. It's the smart developer that can jump right
in and create those tables with little or no thought to design before
starting. I wouldn't attempt it.

I'm just curious about the foreign keys though at this point -- more so
than the actual design process.

For whatever reason, I seem to remove fields until all my tables are
set. Then, I go back and relate the tables by inserting foreign keys,
and I'm just curious what others do.

Susan H.


> Susan,
>
> Whether you do it on paper or on the PC, it usually is an iterative 
> process, at least in my experience.  By that I mean as you go along 
> you will discover that one or more of the tables you have already 
> designed needs to be split since some of the data fields apply only to

> the subject of the table while other data fields does not.  And you 
> will notice that some data fields split over several tables should be 
> combined into one table.
>
> It would be a very simple application, or a very astute individual, 
> where all the relationships are obvious from the beginning.
>
> Charles Wortz
> -----Original Message-----
> From: Susan Harkins [mailto:harkins at iglou.com]
> Sent: Monday 2003 Mar 10 12:50
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] normalization question
>
> Yes, I agree...
>
> but in the process of making your paper lists -- when?
>
>
> ----- Original Message -----
> From: <Mwp.Reid at Queens-Belfast.AC.UK>
> To: <accessd at databaseadvisors.com>
> Sent: Monday, March 10, 2003 1:34 PM
> Subject: RE: [AccessD] normalization question
>
>
> >
> > you do it before turning the PC on when your designing the 
> > structures.
>
> > The theory is that the data is normalised before you actually create

> > the
> tables
> > physically.
> >
> > Martin