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…