Given BOOK(ISBN(PK), Title, PubID(FK), Price, Award) We have…

Given BOOK(ISBN(PK), Title, PubID(FK), Price, Award) We have discovered that the book for ISBN = ‘12345’ has received an award. Write a SPROC that has one parameter to receive the ISBN, and write SQL to update the BOOK table by updating the Award field to ‘1st Prize’.  Then, call the function to update the award field.