Question about normal forms

[fbelfort]

Hi, I'd like to know your opinion about the following problem :



I'm given this table and I'm supposed to say in which Normal Form it is. I'm not sure but I guess in this specific case I need to consider both Toy_ID and Order_ID as primary key. Then one can see that Order_Date ist dependent on Order_ID but not on Toy_ID, then the table should be in 2NF, right ?

The table is not in 3NF because even though Producer is dependent on Toy_ID (at least I think it's dependent), City and Country are not directly but only transitively dependent on Toy_ID. Am I right ?

Thanks !

 

[Guus2005]

I take the fifth on this one. Smells like homework.

 

[jdraw]

Hi, I'd like to know your opinion about the following problem :



I'm given this table and I'm supposed to say in which Normal Form it is. I'm not sure but I guess in this specific case I need to consider both Toy_ID and Order_ID as primary key. Then one can see that Order_Date ist dependent on Order_ID but not on Toy_ID, then the table should be in 2NF, right ?

The table is not in 3NF because even though Producer is dependent on Toy_ID (at least I think it's dependent), City and Country are not directly but only transitively dependent on Toy_ID. Am I right ?

Thanks !

Here's a reference for normalization

http://r937.com/relational.html