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

1.) Consider the problem of determining whether a DFA and a regular expression are equivalent. Express this problem as a language and show that it is decidable. ii) Let ALLDFA = {(A)| A is a DFA and L(A) = "}. Show that ALLDFA is decidable. iii) Let AECFG = {(G)| G is a CFG that generates &}. Show that AECFG is decidable. iv) Let ETM {(M)| M is a TM and L(M) = 0}. Show that ETM, the complement of Erm, is Turing-recognizable. Let X be the set {1, 2, 3, 4, 5} and Y be the set {6, 7, 8, 9, 10). We describe the functions f: XY and g: XY in the following tables. Answer each part and give a reason for each negative answer. n f(n) n g(n) 1 6 1 10 2 7 2 9 3 6 3 8 4 7 4 7 5 6 5 6 Aa. Is f one-to-one? b. Is fonto? c. Is fa correspondence? Ad. Is g one-to-one? e. Is g onto? f. Is g a correspondence? vi) Let B be the set of all infinite sequences over {0,1}. Show that B is uncountable using a proof by diagonalization.

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

1.) Consider the problem of determining whether a DFA and a regular expression are equivalent. Express this problem as a language and show that it is decidable. ii) Let ALLDFA = {(A)| A is a DFA and L(A) = "}. Show that ALLDFA is decidable. iii) Let AECFG = {(G)| G is a CFG that generates &}. Show that AECFG is decidable. iv) Let ETM {(M)| M is a TM and L(M) = 0}. Show that ETM, the complement of Erm, is Turing-recognizable. Let X be the set {1, 2, 3, 4, 5} and Y be the set {6, 7, 8, 9, 10). We describe the functions f: XY and g: XY in the following tables. Answer each part and give a reason for each negative answer. n f(n) n g(n) 1 6 1 10 2 7 2 9 3 6 3 8 4 7 4 7 5 6 5 6 Aa. Is f one-to-one? b. Is fonto? c. Is fa correspondence? Ad. Is g one-to-one? e. Is g onto? f. Is g a correspondence? vi) Let B be the set of all infinite sequences over {0,1}. Show that B is uncountable using a proof by diagonalization.

Can you find the least amount of different numbers to pick from positive numbers (integers) that are at most 100 to confirm two numbers that add up to 101 when each number can be picked at most two times?

Can you find the formula for an that satisfies the provided recursive definition? Please show all steps and justification

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