Re: Need for primary keys
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: amar.padhi@xxxxxxxxx
- Date: Fri, 1 Jun 2007 11:08:53 -0700
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
- Follow-Ups:
- Re: Need for primary keys
- From: Derya Oktay
- References:
- Re: Need for primary keys
- From: amar kumar padhi
Other related posts:
- » Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
- » RE: Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
- » Re: Need for primary keys
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.
- Re: Need for primary keys
- From: Derya Oktay
- Re: Need for primary keys
- From: amar kumar padhi