[AccessD] normalization question

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Mon Mar 10 12:35:00 CST 2003


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
> 



More information about the AccessD mailing list