Re: implement a referential integrity constraint (long)

From: Philipp Post <Post.Philipp_at_googlemail.com>
Date: Fri, 8 May 2009 06:01:15 -0700 (PDT)
Message-ID: <49b7763f-3f9d-4724-bfea-1680e3448fb0_at_q14g2000vbn.googlegroups.com>

> Can anyone suggest a better way? <

Do a web search about "Normal Forms" and get a book about database design

Look up standards. Postal codes have standards. There are ISO country and location codes. A database can enforce them by DRI and CHECK constraints.

Do not confuse the front end (reporting / presentation layer) with the backend (database). How you print addresses on paper, based on local needs is a matter of the reporting tools and not the database.

Sorry, but there are fundamental problems with your design.

Philipp Post Received on Fri May 08 2009 - 15:01:15 CEST

This message: [ Message body ]
Next message: cimode_at_hotmail.com: "Re: webmail user mailbox schema design?"
Previous message: --CELKO--: "Re: implement a referential integrity constraint (long)"
In reply to xyzzy: "implement a referential integrity constraint (long)"
Next in thread: xyzzy: "Re: implement a referential integrity constraint (long)"
Reply: xyzzy: "Re: implement a referential integrity constraint (long)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message