oracle-l-bounce@xxxxxxxxxxxxx gravou em 2005-08-08 09:27:29: > Isn't this a great example of how a better design is a better solution? > Wouldn't > > PATIENT > ======= > PATIENT_PK > .................... > > ALLERGEN > ========= > ALLERGEN_PK > ........................ > > KNOWN_ALLERGIES > ================ > PATIENT_PK -- foreign key > ALLERGEN_PK -- foreign key > IDENTIFIED_DATE > ..... > > > Be a better design? I know it's just a rethorical question, but I couldn't avoid answering: yes! As usual, complexity is better avoided by trying to reach the essentials, not by adding layers -- this being one of the reasons why OO is doomed as a DBMS approach. For example, most NULLs can be dispensed by good modelling in general (and full normalisation in particular), and many triggers can be avoided by creating an equivalent but far simpler constraint. That's part of the reasons why SQL is ultimately doomed and we should all be thinking about using relational systems. -- Leandro Guimarães Faria Corcete DUTRA Administrador de Bases de Dados +55 (11) 4390 5383 Toyota do Brasil Ltda ldutra@xxxxxxxxxxxxx São Bernardo do Campo, SP BRASIL This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference. -- //www.freelists.org/webpage/oracle-l