Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
I am having an error and cannot figure out how to solve this question. Could someone please assist? Please be advised, I am using PostgreSQL as that is what was used in class. Thus, I must use PLPGSQL Code CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction() RETURNS TRIGGER LANGUAGE PLPGSQL AS $$ CREATE TRIGGER Wise_12_bankTrigger AFTER DELETE ON account FOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();

I am having an error and cannot figure out how to solve this question. Could someone please assist? Please be advised, I am using PostgreSQL as that is what was used in class. Thus, I must use PLPGSQL Code CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction() RETURNS TRIGGER LANGUAGE PLPGSQL AS $$ CREATE TRIGGER Wise_12_bankTrigger AFTER DELETE ON account FOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Hello,

I am having an error and cannot figure out how to solve this question. Could someone please assist?

Please be advised, I am using PostgreSQL as that is what was used in class. Thus, I must use PLPGSQL

Code

CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS
$$

CREATE TRIGGER Wise_12_bankTrigger
AFTER DELETE ON account
FOR EACH ROW
EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();

3. Consider the bank database schema given in question (2). Write a SQL trigger to carry out the following action: If an account is deleted, then write a trigger to delete the dependent tuple(s) from the depositor table for every owner of the deleted account. Note that there may be jointly-owned bank accounts. In other words, you are to write a trigger that performs the exact action of an ON DELETE CASCADE clause of a FOREIGN KEY CONSTRAINT. You must submit both your trigger function definition, and your trigger definition. You must name your trigger function: <LastName>_<DOB_DayOfMonth>_bankTriggerFunction You must name your trigger: <LastName> <DOB DayOfMonth>_bankTrigger Where <LastName> is your last name and <DOB DayofMonth> is the day of the month you were born. Below is an example of how I named my trigger function and trigger, respectively: Morabito_05_bankTriggerFunction () Morabito 05 bankTrigger
Transcribed Image Text:3. Consider the bank database schema given in question (2). Write a SQL trigger to carry out the following action: If an account is deleted, then write a trigger to delete the dependent tuple(s) from the depositor table for every owner of the deleted account. Note that there may be jointly-owned bank accounts. In other words, you are to write a trigger that performs the exact action of an ON DELETE CASCADE clause of a FOREIGN KEY CONSTRAINT. You must submit both your trigger function definition, and your trigger definition. You must name your trigger function: <LastName>_<DOB_DayOfMonth>_bankTriggerFunction You must name your trigger: <LastName> <DOB DayOfMonth>_bankTrigger Where <LastName> is your last name and <DOB DayofMonth> is the day of the month you were born. Below is an example of how I named my trigger function and trigger, respectively: Morabito_05_bankTriggerFunction () Morabito 05 bankTrigger
A Bank/postgres@PostgreSQL 13 v Query Editor Query History CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction() 1 2 RETURNS TRIGGER LANGUAGE PLPGSQL 4 AS $$ 7 CREATE TRIGGER Wise_l2_bankTrigger 8. AFTER DELETE ON account 9 FOR EACH ROW 10 EXECUTE PROCEDURE Moreno_15_bankTriggerFunction (); 11 Data Output Explain Messages Notifications ERROR: unterminated dollar-quoted string at or near "$$ CREATE TRIGGER Wise_12_bankTrigger AFTER DELETE ON account FOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();" LINE 5: $$ SQL state: 42601 Character: 128
Transcribed Image Text:A Bank/postgres@PostgreSQL 13 v Query Editor Query History CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction() 1 2 RETURNS TRIGGER LANGUAGE PLPGSQL 4 AS $$ 7 CREATE TRIGGER Wise_l2_bankTrigger 8. AFTER DELETE ON account 9 FOR EACH ROW 10 EXECUTE PROCEDURE Moreno_15_bankTriggerFunction (); 11 Data Output Explain Messages Notifications ERROR: unterminated dollar-quoted string at or near "$$ CREATE TRIGGER Wise_12_bankTrigger AFTER DELETE ON account FOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();" LINE 5: $$ SQL state: 42601 Character: 128
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
JQuery and Javascript
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS