ences Mailings Review View Help AaBbCcD AaBbCcDc AaBbC AaBbCcC 1 Normal No Spac... Heading 1 Heading 2 T Paragraph Styles The functional dependences of the database design (refer to the notation on page 112 of Harrington (2009)). Your determination of the normal form of the design (first or second). Justify your answer. Refactor the design so that it is in at least third normal form. Justify your answer and post your revised design. Keep in mind that during normalization, new foreign keys may be introduced to the table(s). The new functional dependences of the refactored database. Specify the relationships between the tables in your revised design ON THE DATABASE BELOW Client Database Dog Food (food name, brand, food type, food size, food recipe, food price) This normal form could be used by a dog breeder, dog shelter or just a family with a large number of dogs that needs the database for finding and comparing the best recipe for each dog and also the cheapest dog food. It could be easily modified for cat food or any type of pet food. Food name would be the entire name of the bag of dog food such as Hill's Science Diet Adult Large Breed and the primary key. Brand would be the brand of dog food such as Hil's Science Diet. Food type would be what the dog food is for such as small breed, large breed, elderly, canned, etc. Food size would be the weight of the dog food in pounds or ounces. Eood..recipe would be what's included in the dog food such as grain free, chicken, or turkey Food price would be how much the dog food cost per unit