Re: One to One Relationship

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: 18 Mar 2003 11:44:14 GMT
Message-ID: <Xns9342E4A272874Tokenthis@210.49.20.254>

Following up on Wayne Hinch, 18 Mar 2003:

> But if you merge the tables you are not meeting the ERD standards which
> is lots of small tables containing different pieces of information.

It most definitely is NOT an "ERD standard" to have "lots of small tables"! Where the heck did you get that from?

> customer (Two different credit cards). Whereas merging the tables
> together it would be alot of work to implement the functionality above.

That has to do with First-normal form. Not "merging tables". You MUST normalize your logical design. Always. You may in some cases denormalize to simplify your physical design. But that is optional, and AFTER you have normalized the logical design. None of these have anything to do with using or not using a 1:1 relationship between two tables. Particularly if it is an optional one.

> Also what about security?
>

What about it? You can apply security to the tables or to the rows, or both. That is not necessarily dependent on the design or merging tables.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue Mar 18 2003 - 05:44:14 CST