Question: 2. (20 points) Please write a stored procedure named pHW2 2 xxxx based on the Hotel, Room and Booking tables. Your program should take one

2. (20 points) Please write a stored procedure named pHW2 2 xxxx based on the Hotel, Room and Booking tables. Your program should take one argument hotelname and it should meet the following 2 test cases (10 points) If the given hotel name 2B 10 points) If the given hotel name is 2A. is in the Hotel table, please display the room type empty or null, please display an error message and the number of room booked for each room "invalid hotel name" type for the given hotel name. mysql call pHW2 2 XXXX(NULL); mysql call pHW2 2 xxxx ('Grosvenor'); mysql call pHW2 2 xxxx(); I type I count l message I double l 2 l l Please input a valid hotel name. I family I 1 l single l 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

All of them Please write stored procedures and stored functions based on the dreamhome database. You must create and test your programs on database CPS3740 2017S at server imc.kean.edu. Your program...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Give condition for tracking down the most likely arrangement of grammatical feature (POS) labels that could be used by a stochastic POS tagger. You ought to accept a bigram model. [5 marks] (b) Given...

home / study / engineering / computer science / computer science questions and answers / please do not spam answer me like other chegg people ... Question: Please do not spam answer me like other...

rumal of Information Technology Teaching Cases 2011 CNC Mac 2016/1 Teaching case From theme park to resort: customer information management at Port Aventura Mariano A Hervs, Joan Rodon, Marc Planell,...

Final Backgrounder Saskatchewan 831 489.6 420.2 14.2% Alberta 1,569 2,214.4 1,791.5 19.1% British Columbia 3,277 2,591.1 2,215.0 14.5% Yukon 167 73.1 66.3 9.3% Northwest Territories 99 53.4 44.9...

please help with this question and post it with comments of work to undersatnd the program Question 1: Booking System (100 points) For this question, you will write several classes, and then create...

Please write in CPP language. 1. Overview The first project is going to be a MIPS simulator. In general, you will be building a program that simulates the execution of an assembly language file. The...

If the Taylor polynomial of order 3 generated by the function 26 f(x) = 2V at a = 2 is P;(1) = A+ B(x 2) + C(x 2) + D(x 2) then C +D = 29 29 19 19

The following data relating to direct materials cost for October of the current year are taken from the records of Good Clean Fun Inc., a manufacturer of organic toys: Quantity of direct materials...

The most an investor in a convertible preferred stock can lose is the value of the common stock into which the preferred stock may be converted

Which sen of the following statements is cerrect? b. Wonn of the statimens are cotred c. Acteppery thoutd addess all sinifiant isk areas wim the inylementafiet of contws Af Moving to aniother...

9. Review the accompanying sample tasks and task ratings for the electronic technicians job. What tasks do you believe should be emphasized in the training program? Why?

5. Were positive consequences offered for good performance? Was good performance not rewarded? For example, if employees are dissatisfied with their compensation, their peers or a union may encourage...

4. Were performance expectations clear (input)? Were there any obstacles to performance such as faulty tools or equipment?