Hi,

I have the following table which I am trying to convert to BCNF (3NF). It represents items in a smart fridge, each item is represented by a row...

food_id &nbsp &nbsp &nbsp description &nbsp &nbsp &nbsp food_type &nbsp &nbsp &nbsp re-order_level &nbsp &nbsp &nbsp brand &nbsp &nbsp &nbsp expiry_date

m021 &nbsp &nbsp &nbsp &nbsp &nbsp Mince &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Meat &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 3 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Tesco &nbsp &nbsp &nbsp &nbsp &nbsp 28 March

v055 &nbsp &nbsp &nbsp &nbsp &nbsp Peas &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp &nbsp &nbsp Veg &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 1 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp BirdsEye &nbsp &nbsp &nbsp &nbsp &nbsp 5 May

m025 &nbsp &nbsp &nbsp &nbsp &nbsp Mince &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Meat &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 3 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Tesco &nbsp &nbsp &nbsp &nbsp &nbsp 30 March

v063 &nbsp &nbsp &nbsp &nbsp &nbsp Chips &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Veg &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 2 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp McCain &nbsp &nbsp &nbsp &nbsp &nbsp 9 September

v072 &nbsp &nbsp &nbsp &nbsp &nbsp Peas &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp veg &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 2 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Tesco &nbsp &nbsp &nbsp &nbsp &nbsp 8 June

So far I have made the following tables

table1 (food_id*, description, food_type, brand, expiry_date)
table2 (description^, brand^, re-order_level)

* = primary key
^ = foreign key

I need to know, is this correct and is there any thing more I can do ?

Any help would be greatly appreciated, im really stuck on this...

Thanks

Chris.

Hi,

Is this for school?

Yea,

Its part of a larger assignment. Im really stuck on it at the moment and I need to know if im working in the right direction.

Chris

I'll give you a hint.

Your example is pretty simple. Almost every column could be justified as being in its own table.

Not quite every all, but almost every one.

If this were a real world problem, folks would be more inclined to chime in.