QuestionIn the relational tables below, we see three tables of a veterinary system, all providing unique information on a specific dog. Based on these instances, answer the following questions: Food Type Good Boy Y $1573$ Dry $2684$ WetN TABLE BBio Measure HeightWeight $3795157315214806$ Dry Y Wet TABLE CCare$\_$Info $9737952713048061573$ TABLE A: Pet Info Name BreedColor FidoBeagle Brown$/$White Rex Pekingese White Bubbles RottweilerBlack Age $268437954806$ Cujo Chihuahua Gold Write the DDL statement for creating table B$,$ make sure that the statement maintains referential integrity. Get the hight $,$ weight and age of the dog named $"$ Rex". $3.$ For each food type that the dogs have, find the average age of the dogs that have each food type $.$ Retrieve a list of distinct breads in the system $.$ By using Nesting Query, get the Tag# and names of the dogs that are good. Change the age of the dog number $3795"$ to be $6$ years old. Delete column Good$\_$Boy" from table