(a) UNION set operator: The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values. Syntax: QUERY UNION QUERY; Consider two tables: Table creation: CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY); CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE)); Inserting values: INSERT INTO VENDOR VALUES(123); INSERT INTO VENDOR VALUES(124); INSERT INTO VENDOR VALUES(125); INSERT INTO VENDOR VALUES(126); INSERT INTO PRODUCT VALUES('ABC', 125); INSERT INTO PRODUCT VALUES('DEF', 124); INSERT INTO PRODUCT VALUES('GHI', 124); INSERT INTO PRODUCT VALUES('JKL', 123);

Question

General accounting

Answer 1

Question

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

General accounting

JOB UPDATE Apply on- VinkJobs.com @ OR Search "Vinkjobs.com" on Google COMPANY JOB PROFILE JOB LOCATION INTELLIFLO APPLICATION DEVELOPER MULTIPLE CITIES GLOBAL LOGIC SOFTWARE ENGINEER/SDET DELHI NCR SWIGGY SOFTWARE DEVELOPMENT BENGALURU AVALARA SOFTWARE ENGINEER (WFH) MULTIPLE CITIES LENSKART FULL STACK DEVELOPER MULTIPLE CITIES ACCENTURE MEDPACE IT CUST SERVICE SOFTWARE ENGINEER MUMBAI MUMBAI GENPACT BUSINESS ANALYST DELHI NCR WELOCALIZE WORK FROM HOME MULTIPLE CITIES NTT DATA BPO ASSOCIATE DELHI NCR

+is+how+many+tree+in+ipl&rlz=1C1GCEA_enIN1122IN1122&oq=1+dot+ball+is+how+many+tree+in Google 1 dot ball is how many tree in ipl All Images News Videos Short videos Shopping Web More 500 trees 4) हिन्दी में In English The step was a part of the Board of Control for Cricket in India's green initiative. The BCCI, having partnered with the Tata Group, has promised to plant as many as 500 trees for every dot ball bowled in the Indian Premier League. 25 Mar 2025 Sportstar https://sportstar.thehindu.com > Cricket IPL IPL News IPL 2025: Why are green tree symbols showing up for every ... A Translate to fo-d About featured snippets . Feedback Tools

Answer 2

Question

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 3

Question

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 4

Question

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 5

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 6

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 7

Chapter 8, Problem 18RQ

Program Plan Intro

(a)

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax:

QUERY UNION QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 8

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 9

Program Plan Intro

(b)

UNION ALL set operator:

The UNION ALL set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains duplicate values.

Syntax:

QUERY UNION ALL QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 10

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 11

Program Plan Intro

(c)

INTERSECT set operator:

The INTERSECT set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that are common in both the tables.

Syntax:

QUERY INTERSECT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 12

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 13

Program Plan Intro

(d)

EXCEPT/ MINUS set operator:

The MINUS set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains the values (rows) that appear in the first table but not in the second table. The word “EXCEPT” can also be used in the place of “MINUS”.

Syntax:

QUERY EXCEPT QUERY;

Consider two tables:

Table creation:

CREATE TABLE VENDOR(VEND_CODE INT PRIMARY KEY);

CREATE TABLE PRODUCT(PROD_CODE VARCHAR(5), VEND_CODE INT,FOREIGN KEY (VEND_CODE) REFERENCES VENDOR (VEND_CODE));

Inserting values:

INSERT INTO VENDOR VALUES(123);

INSERT INTO VENDOR VALUES(124);

INSERT INTO VENDOR VALUES(125);

INSERT INTO VENDOR VALUES(126);

INSERT INTO PRODUCT VALUES('ABC', 125);

INSERT INTO PRODUCT VALUES('DEF', 124);

INSERT INTO PRODUCT VALUES('GHI', 124);

INSERT INTO PRODUCT VALUES('JKL', 123);

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 17

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 18

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 19

Trending nowThis is a popular solution!

Answer 20

Trending nowThis is a popular solution!

Answer 21

Trending nowThis is a popular solution!

Answer 22

Trending now

Answer 23

This is a popular solution!

Answer 24

See solution

Check out sample textbook solution

Answer 25

Ch. 8 - What is a cross join? Give an example of its...Ch. 8 - What three join types are included in the outer...Ch. 8 - Using tables named T1 and T2, write a query...Ch. 8 - Prob. 4RQ Ch. 8 - Prob. 5RQ Ch. 8 - Prob. 6RQ Ch. 8 - Prob. 7RQ Ch. 8 - What does it mean to say that SQL operators are...Ch. 8 - Prob. 9RQ Ch. 8 - Prob. 10RQ

Solution Summary: The author describes the UNION set operator, which is used to combine the output of two or more queries and produce a result.

Chapter 8 Solutions