Cambridge Pet Store is a local business that sells pet food to customers in the Cambridge Area.The table below shows sample data that are being stored by Cambridge Pet Store in order to keep track of the costs of the pet food that it purchases for resale.The FoodID is a unique number that identifies each pet food.The SellerID identifies unique vendors of the pet foods that Cambridge Pet Store purchases.

a)Analyze the table and sample data.Describe any normalization rule violations.

b)What problems could Cambridge Pet Store experience as a result of the design of the table the company uses to maintain records of pet food prices?

c)Correct any problems you identified with the table design by creating one or more new tables that will correct the problems. You do not need to create data for the new table(s).You should only show the design of the table(s). Your table(s) should be in third normal form.Identify all primary and foreign keys.Use the following notation:

Tables in ( )

Primary keys Underlined

Foreign keys in Italics

Cambridge Pet Store sample data:

FoodIDFood DescriptionSellerIDFood cost

F1Large dogPetWorld$55.00

F1Large dogPetPlace$51.00

F3PuppyPetWorld$24.00

F3PuppyFoodStore$21.00

F3PuppyPetPlace$23.00