Ed W wrote: > Hi > >> Ok, I look at normalization as a mathematical method of ensuring that >> the data can represent anything it needs to.
> Address should probably be nomalised out of the entity in order to allow > having multiple addresses per entity (eg two delivery addresses) Addresses (locations in the model) are completely separated from everything already :) Joshua D. Drake > > How does this sound? We probably don't want this to get > overcomplicated, hence the suggestion just to duplicate records when > they are changed and hide the old records so that they don't normally > show up (but are available to be referenced by old invoices) > > Sound sensible? > > Ed W > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Ledger-smb-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
