Re: Normalising a two-to-one relationship

David> Remember, normalization is a design principle, not an absolute golden David> rule.

Brief and perhaps off topic note: some hold that normalization is part of the _analysis_, not the _design_ . I.e., normalization is something that is inherent in the part of real world (or 'business logic') that is being modeled. The analyst's task is to uncover this web of idealized relationships, then map it to some (usually less idealized) form.

                                                                      Philip

-- 
C++: The power, elegance and simplicity of a hand grenade. (Kenneth C. Dyke)
-----------------------------------------------------------------------------
Philip Lijnzaad, lijnzaad_at_ebi.ac.uk \ European Bioinformatics Institute,rm A2-08


+44 (0)1223 49 4639                 / Wellcome Trust Genome Campus, Hinxton

+44 (0)1223 49 4468 (fax)           \ Cambridgeshire CB10 1SD,  GREAT BRITAIN

PGP fingerprint: E1 03 BF 80 94 61 B6 FC  50 3D 1F 64 40 75 FB 53