Question
Use the script files HenryPSQL and HenryInventory to create the Henry Book Store database in your MySQL Database Server. Write a stored procedure (spGetAllPubStatsFL, where
Use the script files HenryPSQL and HenryInventory to create the Henry Book Store database in your MySQL Database Server.
Write a stored procedure (spGetAllPubStatsFL, where F and L refer to your first and last name) and load it into your MySQL Database where you also created the Henry Book Store database tables. The stored procedure is to output various statistics for all publishers in the database. This stored procedure will call another stored procedure named (spGetPubStatsFL) that accepts a publisher code as input and returns the required statistics only if the given publisher code exists (Notify the caller if the publisher code does not exist). The information output is:
The name of the publisher.
The number of distinct authors who have written book(s) for this publisher.
The number of different books published by this publisher.
The title of the book published by this publisher that has the highest number of onHand units collectively in all branches of Henry Books.
The number of onHand units for the above book.
The cumulative sum of onHand units from all branches for all books published by this publisher.
Stored procedure spGetAllPubStatsFL() must create a permanent database table in which it stores the results returned by stored procedure spGetPubStatsFL() for each Publisher code defined in the Publisher table. Every time spGetAllPubStatsFL() is invoked, it should clean up the permanent table before it invokes spGetPubStatsFL().
please help
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started