Re: Autoupdate field?

2008-07-13 Thread Adam Fast
The proper design decision there (if Mary's phone number and her family (the Smith's) phone number will /always/ be the same) is to store the data only once - avoiding duplication. This is what Juanjo is saying. Since mary.family = Smith, mary.family.telephone_home = Mary's phone number. If you

Re: Autoupdate field?

2008-07-12 Thread Xan
Yes, but if mary is a Person and Smith is a Family, and mary belongs to Smith Family (that is mary.family = Smith), how to change mary.hometelephone if Smith.hometelephone change? Thanks a lot, Xan. On Jul 6, 10:02 pm, Juanjo Conti <[EMAIL PROTECTED]> wrote: > I you want your data to be normaliz

Re: Autoupdate field?

2008-07-06 Thread Juanjo Conti
I you want your data to be normalized, telephone_home char(9) should not be an attribute of Person. If mary is a Person you always can do: mary.family.telephone_home to get her telephone_home. Juanjo -- mi blog: http://www.juanjoconti.com.ar --~--~-~--~~~---~--~--

Autoupdate field?

2008-07-06 Thread Xan
Hi, I think in family class and person class. I put in pseudocode: Class Family string name telephon-home char(9) Class Person string name string surname telephone-home char(9) mobile-phone char(9) Every Person belongs to a Family. How can I update Per