Re: An interesting question about normalization

In article <388B893C.ED967077_at_pcmagic.net>,   Yuriy <vlad_at_pcmagic.net> wrote:
> It is possible for all databases to be converted to BCNF ?
>
> If yes How would you convert the following fragment of database to
 Boyce
> Code normal Form ?
>
> Part # | part name | Supplier # | Supplier name | quantity |buy price|
> sell price|
> 10 | part a | 200 | Atom | 30 | 51 |
> 60 |
> 10 | part a | 250 | Joker | 30 | 52 |
> 60 |
> 20 | part b | 200 | Atom | 34 | 15 |
> 30 |
> 20 | part b | 300 | Metal | 34 | 12 |
> 30 |
>
> I was able to get to 3 NF
> and do not know how to proceed further
>
> My e-mail is vlad_at_pcmagic.net
> Thank you very much for your help
> Sincerely yours, Yuriy
>

Yuriy,

Normal forms are defined under certain FDs (functional dependencies). But you didn't provide FDs in this question?

Quan.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 00:00:00 CET