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

Other related posts: