Re: Beginner help needed in database design

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 01 Feb 2005 17:57:25 +0100
Message-ID: <ctocan$mtd$1@news5.zwoll1.ov.home.nl>

DA Morgan wrote:
> Frank van Bortel wrote:
>

>> One thing strikes as odd: primary keys are a techie thingy, something
>> most database systems need internally; it's not a design, nor a logical
>> thing - it's the implementation.

>
>
> Whoa ... time out. Excuse me. And utterly untrue. No database I can
> think of "needs" a primary key. Common sense, data integrity,
> performance, and scalability demand them.
>
> Everything else you said made sense so where did this come from?
Right - wrong word.

There's no need to use primary keys, but -if used- a primary key is a technical aspect, not a conceptual or modelling (or modeling for the other English speakers) thing.

Hope that's more like it, and apologize for any confusion

-- 
Regards,
Frank van Bortel

Received on Tue Feb 01 2005 - 10:57:25 CST