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_at_gmail.com> wrote:
>
> On 6/1/07, amar kumar padhi <amar.padhi_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l