Re: Im stuck in a black hole!

allanwtham_at_yahoo.com (godmann) wrote in message news:<95cd51c.0205200609.6891bf02_at_posting.google.com>...
> Sted,
>
> Try a textbook by Elmasri from library. It was the textbook I used in college
> and it explains really well, the functional dependency, the closure, 1NF,
> 2NF, 3NF, Multivalue NF, even BoyceCodd NF. I can't remember much now. I used
> to do lots of these.
>

I remember using this phrase "functional dependency" many times in my first interview for DBA jobs when I was asked a question on normalizatoin, and my answer didn't work very well!

> To enlighten some, what he is trying to do is the rule for normalization.
> Normalization is employed in ER design. DBA do not do that job.
>

DBAs design databases from their past experience and common sense, instead of FD rules. As a result, most of the real world data models look more or less like 3NFs. I have not seen a single Boyce Codd NF or beyond.

> This thread is more like a college school work problem.
>
> Try to get that textbook. It's the best to my knowledge and read under the
> chapter, Normalization.
>
>
> Allan W. Tham
> Oracle DBA
Received on Tue May 21 2002 - 11:21:55 CDT