Hi, I need to normalize these two tables (zoo.png) in first normal form (No repeating groups – each cell can only hold one piece of information, no repeating groups), in second form (No partial depen

Hi, 

I need to normalize these two tables (zoo.png) in first normal form (No repeating groups – each cell can only hold one piece of information, no repeating groups), in second form (No partial dependencies – the primary key must be functionally reliant on each non-key attribute) and after in third normal form (No transitive dependencies – all attributes other than the primary key must rely on primary key and only the primary key)

NOTE: Tables are not in first normal form. I need to separate the meal times and move weight and type of food in different tables.

Show more