Question 1 Write the SQL to create the KENNEL table. The picture below details the columns, data types and constraints for this table. Make sure you name your constraints. Now…

Your task is to design a system that allows smooth operation of a library system. That is, create stored procedures that will fulfill the user requirements given below. Please provide…