a. Trigger: The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description. If the stated trigger condition meets up, then the mentioned action in the trigger has been performed. There are three parts of trigger; they are: Event: It specifies the change to be made, such as an UPDATE or DELETE of a record. Condition: It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger. Action: The action performed after the start of the trigger. The syntax to create a trigger is as given below: CREATE TRIGGER trigger_name {BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON table_name [FOR EACH{ROW|STATEMENT}] [WHEN(condition)] <triggered SQL statement here>;

Question

Design a dynamic programming algorithm for the Longest Alternating Subsequence problem described below: Input: A sequence of n integers Output: The length of the longest subsequence where the numbers alternate between being larger and smaller than their predecessor The algorithm must take O(n²) time. You must also write and explain the recurrence. Example 1: Input: [3, 5, 4, 1, 3, 6, 5, 7, 3, 4] Output: 8 ([3, 5, 4, 6, 5, 7, 3, 4]) Example 2: Input: [4,7,2,5,8, 3, 8, 0, 4, 7, 8] Output: 8 ([4, 7, 2, 5, 3, 8, 0,4]) (Take your time with this for the subproblem for this one)

Answer 1

Question

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Design a dynamic programming algorithm for the Longest Alternating Subsequence problem described below: Input: A sequence of n integers Output: The length of the longest subsequence where the numbers alternate between being larger and smaller than their predecessor The algorithm must take O(n²) time. You must also write and explain the recurrence. Example 1: Input: [3, 5, 4, 1, 3, 6, 5, 7, 3, 4] Output: 8 ([3, 5, 4, 6, 5, 7, 3, 4]) Example 2: Input: [4,7,2,5,8, 3, 8, 0, 4, 7, 8] Output: 8 ([4, 7, 2, 5, 3, 8, 0,4]) (Take your time with this for the subproblem for this one)

Design a dynamic programming algorithm for the Coin-change problem described below: Input: An amount of money C and a set of n possible coin values with an unlimited supply of each kind of coin. Output: The smallest number of coins that add up to C exactly, or output that no such set exists. The algorithm must take O(n C) time. You must also write and explain the recurrence. Example 1: Input: C24, Coin values = = [1, 5, 10, 25, 50] Output: 6 (since 24 = 10+ 10+1+1 +1 + 1) Example 2: Input: C = 86, Coin values = [1, 5, 6, 23, 35, 46, 50] Output: 2 (since 86 = 46+35+5)

Design a dynamic programming algorithm for the Longest Common Subsequence problem de- scribed below Input: Two strings x = x1x2 xm and y = Y1Y2... Yn Output: The length of the longest subsequence that is common to both x and y. . The algorithm must take O(m n) time. You must also write and explain the recurrence. (I want the largest k such that there are 1 ≤ i₁ < ... < ik ≤ m and 1 ≤ j₁ < ... < jk ≤ n such that Xi₁ Xi2 Xik = Yj1Yj2 ··· Yjk) Example 1: Input: x = 'abcdefghijklmnopqrst' and y = 'ygrhnodsh ftw' Output: 6 ('ghnost' is the longest common subsequence to both strings) Example 2: Input: x = 'ahshku' and y = ‘asu' Output: 3 ('asu' is the longest common subsequence to both strings)

Answer 2

Question

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 3

Question

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 4

Question

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 5

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Answer 6

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Answer 7

Chapter 8, Problem 9TD

Program Plan Intro

a.

Trigger:

The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.

If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.

There are three parts of trigger; they are:

Event:

It specifies the change to be made, such as an UPDATE or DELETE of a record.

Condition:

It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.

Action:

The action performed after the start of the trigger.

The syntax to create a trigger is as given below:

CREATE TRIGGER trigger_name

{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON

table_name

[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]

<triggered SQL statement here>;

Answer 8

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Answer 9

Explanation of Solution

b.

Query to create trigger:

CREATE OR REPLACE TRIGGER UPD_CUSTOMER

AFTER UPDATE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION + ((:NEW.BALANCE - :OLD.BALANCE)*RATE);

END;

Explanation:

The above query is used to create a trigger named “UPD_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is inserted in the “CUSTOMER” table...

Answer 10

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Answer 11

Explanation of Solution

c.

Query to create trigger:

CREATE OR REPLACE TRIGGER DEL_CUSTOMER

AFTER DELETE ON CUSTOMER FOR EACH ROW

BEGIN

UPDATE REP

SET COMMISSION = COMMISSION - (:OLD.BALANCE * RATE);

END;

Explanation:

The above query is used to create a trigger named “DEL_CUSTOMER” to update the “COMMISSION” contents in the “REP” table whenever a record is delete in the “CUSTOMER” table...

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 15

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 16

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 17

Trending nowThis is a popular solution!

Answer 18

Trending nowThis is a popular solution!

Answer 19

Trending nowThis is a popular solution!

Answer 20

Trending now

Answer 21

This is a popular solution!

Answer 22

See solution

Check out sample textbook solution

Answer 23

Ch. 8 - Prob. 1RQ Ch. 8 - Prob. 2RQ Ch. 8 - Prob. 3RQ Ch. 8 - Prob. 4RQ Ch. 8 - Prob. 5RQ Ch. 8 - Prob. 6RQ Ch. 8 - Prob. 7RQ Ch. 8 - Prob. 8RQ Ch. 8 - Prob. 9RQ Ch. 8 - In PL/SQL, how do you assign variables the same...

Solution Summary: The author explains the syntax to create a trigger, which is executed at the time of data modification or meets some data description.

Explanation of Solution

Explanation of Solution

Chapter 8 Solutions