AW: Re[2]: V4MD Looking for ideas and solutions for searching doubleentries

[Ruslan Zasukhin]

on 10/2/03 6:35 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

>> Betreff: Re[2]: V4MD Looking for ideas and solutions for
>> searching doubleentries
>> 
>> Hello Ruslan,
>> 
>>       I would say that this example is not usual thing.
>>       Because of ONE main reason.
>>       It has a bad table design.
>> 
>>       Have a look at your table definition.
>>       We need to have some unique criteria for persons! - that's all
>> 
>>       Each person has something unique...
>>       Credit card number, passport, taxID and so on..
> 
> I do not agree Ivan, because very often the unique fields may not be filled
> out or are not in the database design.
> Many DBs exist with Name, Adress etc but without Credit Card Number,
> passport ...

Ivan means that you can do normalization of your tables.

If you don't know what is normalization you need read some book on DB
DESING.

The main idea:  
    you move into table Person data about this Person.
    and this table will not have 2 records with Florian Bogeschdorfer
    by definition.

Other tables will have pointer to this table.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------