[AccessD] normalization question

Charlotte Foust cfoust at infostatsystems.com
Mon Mar 10 13:43:00 CST 2003


Yes, Martin.  And we all know how closely theory matches reality. <vbg>

Charlotte Foust

-----Original Message-----
From: Mwp.Reid at Queens-Belfast.AC.UK
[mailto:Mwp.Reid at Queens-Belfast.AC.UK] 
Sent: Monday, March 10, 2003 10:34 AM
To: accessd at databaseadvisors.com
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

(<:



Quoting Charlotte Foust <cfoust at infostatsystems.com>:

> I tend to do it at the time so I don't forget.  Of course, as we get 
> older our memory ... Uh, what was I saying?  <vbg>
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Susan Harkins [mailto:harkins at iglou.com]
> Sent: Sunday, March 09, 2003 3:36 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] normalization question
> 
> 
> When you remove a field to another table (for whatever reason), do you

> immediately create the foreign key in the original table, or do you 
> wait until you've completely normalized each table and then return to 
> the tables and insert all the foreign keys then?
> 
> I tend to do it later because the nature of a single field can change.
> 
> Does anyone know if the relational model requires a particular 
> routine?
> 
> Just curious.
> 
> Susan H.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list