Question: Write a row-level PL/SQL triggers 8. (20 points) Write a row-level PL/SQL trigger. The purpose of the trigger is to provide a warning when a

Write a row-level PL/SQL triggers

8. (20 points) Write a row-level PL/SQL trigger. The purpose of the trigger is to provide a warning when a guide is assigned to lead an outing for which the guide is not qualified. The trigger should meet the following requirements a. The trigger should be named QUAL GUIDE TRG. b. The trigger should run only after inserting a new row in the OUTING table or updating the GEmpNum attribute in the OUTING table The outing being inserted or updated is associated with a specific tour. Determine if the guide is qualified for that tour if the guide is not qualified for the tour related to this outing, output a warning message d. that the guide is not qualified (eg. Warning: Unqualified guide assigned to outing.")

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!

Describe one specific section which surprised you. Explain the concept that was surprising and explain why I Self-Management Copyright 2007. Arnacorn. All rights reserved. Selfmanagement happens when...

CERTIFICATE IV IN FINANCE AND MORTGAGE BROKING - FN540820 Page 1 UNIT 9 MANAGE PERSONAL AND PROFESSIONAL DEVELOPMENT Unit Code: BSBPEF501 This unit describes the skills and knowledge required to...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Category Creativity Techniques A to Z This A to Z of Creativity and Innovation Techniques, provides an introduction to a range of tools and techniques for both idea generation (Creativity) and...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

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

PLG-120 Week 4 Lecture Notes To begin your analysis of the legal issue you have been asked to address, you must identify the governing rule of law. Articulating the legal rule is, of course, the...

tes In the article, Don Norman suggests organizing screens and menus functionally, designing commands and menu choices to be distinctive, and making it difficult for users to take irreversible...

A debt of $5000 can be repaid, with interest at 8%, by the following payments. Year Payment 1...........................$ 500 2...........................1000 3...........................1500...

Consider the FI in problem (6). a. What additional risk exposure problems does the FI face? b. What are some possible solutions to the duration mismatch and the illiquidity problems? c. What...

The return on equity for 2 0 0 8 is 1 3 . 8 % how do you get that?

Exercise 4-19A Recording sales, purchases, shipping, and returns: buyer and seller-periodic LO P5 Sydney Retailing (buyer) and Troy Wholesalers (seller) enter into the following transactions. May 11...

=+How many positions does the organization need to fill? Are these needs shortterm (less than a year) or long-term (greater than a year)?

=+j Explain the essential nature of repatriation.

=+j Does the organization need applicants for short-term assignments or longterm assignments?