Re: Need for primary keys

Hi Brian,

What about use of unique indexes?  Maybe, in your db there exists unique
indexes instead.

And I wonder if this is a datewarehouse or an OLTP database. We have a DWH
for example. We got no PKs in partitioned tables, we prefer using local
unique indexes, instead of using global PKs in partitioned tables. It has
lots of advantages.

Also 3nf mostly suits with OLTP systems. Discussion of this topic may help
to envision our thoughts.

Regards,
Derya.

On 6/1/07, Jared Still <jkstill@xxxxxxxxx> wrote:


On 6/1/07, amar kumar padhi <amar.padhi@xxxxxxxxx> wrote:
>
> Hi Brain,
> - Constraints require Normalization and there are deviations in design
> methodologies. For performance and data accessibility reasons, some
> projects prefer not to normalize above 2F, some go till 3F.
>

Non 3nf will lead to data errors.

For that matter, not going to 4nf will lead to data errors.
There are alternatives for reporting.

Materialized views for instance.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: