Question: A PL/SQL procedure which assigns a ticket to a support staff. The procedure takes a ticket ID and a staff ID as input and does

A PL/SQL procedure which assigns a ticket to a support staff. The procedure takes a ticket ID and a staff ID as input and does the following steps.

1) it checks whether there is a ticket with the given ticket ID. If not print a message invalid ticket ID and stops.

2) it then checks whether a support staff has the input staff ID. If not print a message invalid staff ID and stop.

3) it assigns the ticket to the support staff (update the sid in ticket table), update status to 2, and insert a row into ticket_detail with appropriate tkid, sid, tdtime as current time (systimestamp), and content as 'ticket assigned to support staff'.

Please call this procedure with an invalid input and a valid input.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solution Here is a PLSQL procedure that assigns a ticket to a support staff performing the necessary ... View full answer

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!

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...

Based on the scenario I need to finish four tasks: -Add a moving bullet actor -Shoot a bullet when the player presses the spacebar key -Destroy a rock when the bullet hits the rock -Increase the...

Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...

/* FILE: FLIX2YOU_data-load.txt */ /* Script to populate tables for FLIX2YOU .. current schema before revision */ /* Written by Gary Heberling on July 2, 2012 */ /* For IST210 world campus Penn State...

(Conceptual IssuesEquity) Statements of Financial Accounting Concepts set forth financial accounting and reporting objectives and fundamentals that will be used by the Financial Accounting Standards...

6.61 Wires manufactured for use in a certain computer system are specified to have resistances between 0.12 and 0.14 ohm. The actual mea- P(-z0 Z z0) = 0.95 P(-z0 Z z0) = 0.90 P(Z z0) = 0.617...

=+g) Are any fourteen points in a row alternatively increasing and decreasing? h) Based on your answers to parts bg, what do you conclude?

American football is the highest paying sport on a per-game basis. The quarterback, considered the most important player on the team, is appropriately compensated. A sports statistician wants to use...

The authors of the paper What Valuation Models Do Analysts Use state: contrary to our expectations, some analysts who construct explicit multi-period valuation models still adopt a comparative...

MBA 708 Essentials of Financial Statement Analysis Week 6 Case Study: Transaction and Financial Analysis Tallulah Company has been in business for several years and is publicly traded on a major U.S....

Consider the following function, whose functional form changes for different intervals alongPlease provide detailed steps for this matlab programme. answers should not be copied from AI rather I want...

Q-2) In order to comment on whether the design specifications are being matched or not, perform relevant hypothesis tests and calculate the p-value for each. What will you conclude? Assume you are...

A Cancer Testing Center has been presented with a proposal to offer a new diagnostic procedure that would require the purchase of a specialized piece of equipment.This piece of equipment offers...

For the dependent variable Y and the independent variables X1 and X2, the linear regression model is given by: Y=0.08059*X1-0.16109*X2+5.26570. Complete the following table: Actual Y X1 X2 Predicted...

For the beam and loading shown, use discontinuity functions to compute: (a) the deflection VA of the beam at A, and (b) the deflection Vmidspan of the beam at midspan (i.e., x = 2.7 m). Assume a...

Which of the following is NOT an external trend that affects the use of mobile marketing? Multiple Choice People use mobile devices multiple times a day. Smartphone and tablets are not as popular as...

In the code below, the sum method computes the sum of all integers in a file. The main method calls it with the name of a file and prints the result. Rearrange the lines of code.

Planning: Creating an Audience Profile; Collaboration: Team Projects. Compare the Facebook pages of three companies in the same industry. Analyze the content on all available tabs. What can you...

Describe a strategy for using the various requirements elicitation techniques in a project.

1. Charlie is a project manager for a new system under development for a national mortgage processing company. A common experience for IS managers today is to lose experienced IS staff members, who...

Draw a level 0 data flow diagram (DFD) for the health club system in Exercise G, Chapter 4.

Use the areas labeled in the market represented in Figure 5P-7 to answer the following questions. a. What area(s) are consumer surplus at the market equilibrium price? b. What area(s) are producer...

In which of the following situations can you say, without further information, that consumer surplus decreases relative to the market equilibrium level? a. Your state passes a law that pushes the...

Assume the market for wine is functioning at its equilibrium. For each of the following situations, say whether the new market outcome will be efficient or inefficient. a. A new report shows that...