Re: Im stuck in a black hole!

allanwtham_at_yahoo.com (godmann) wrote in message news:<95cd51c.0205220636.74e83bb9_at_posting.google.com>...
> Funny thing is I see people who never know FD yet design ERDs. I
> always
> question the designs by such people. No, DBAs do not do design.
> However, it's
> very interesting to have a peek of some designs and I being DBA from
> ERDs background have to shake my head... Most of the times, people get
> away with
> a bad design cuz normally a bad design only shows its ugliness after a
> while.
> As data grows...the design will get more apparent.
>
> BCNF is not easy to reach. In industry, 3NF is good enough. 4NF or
> multi-value
> NF is good in classroom only. I used to love this stuff..most of the
> times,
> people do not abide in rules... it only takes a little leaven to
> leaven the
> whole lump. A good project starts with good ERDs PERIOD
>

Precisely. I hope I didn't sound as if I was promoting higher forms of normalization. Cautions need to be taken with anything above 3NF, even if opportunities are there. Those are interesting research topics. But performance is not a big part of their consideration.

> Allan w. Tham
> Oracle DBA
Received on Wed May 22 2002 - 15:17:43 CDT