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

(Short-answer) b. Continue from the previous question. Suppose part of the data you extracted from the data warehouse is the following. Identify the missing values you think exist in the dataset. Use Column letter and Row number to refer to each missing value in the dataset. Please write down how you want to address each particular missing value (you can group them if they receive same treatment). For imputation, you do not need to calculate the exact imputed values but just describe what kind of value you want to use to impute.

Answer 1

Question

Chapter 7, Problem 23RQ

(a)

Program Plan Intro

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);

(b)

Program Plan Intro

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);

(c)

Program Plan Intro

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);

(d)

Program Plan Intro

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

(Short-answer) b. Continue from the previous question. Suppose part of the data you extracted from the data warehouse is the following. Identify the missing values you think exist in the dataset. Use Column letter and Row number to refer to each missing value in the dataset. Please write down how you want to address each particular missing value (you can group them if they receive same treatment). For imputation, you do not need to calculate the exact imputed values but just describe what kind of value you want to use to impute.

Please original work Locate data warehousing solutions offered by IBM, Oracle, Microsoft, and Amazon Compare and contrast the capabilities of each solution and provide several names of some organizations that utilize each of these solutions. Please cite in text references and add weblinks

Need Help: Which of the following statements about confusion matrix is wrong A) Confusion matrix is a performance measure for probability prediction techniques B) Confusion matrix is derived based on classification rules with cut-off value 0.5 C) Confusion matrix is derived based on training partition to measure a model’s predictive performance D) None of the above

Answer 2

Question

Chapter 7, Problem 23RQ

(a)

Program Plan Intro

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);

(b)

Program Plan Intro

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);

(c)

Program Plan Intro

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);

(d)

Program Plan Intro

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 7, Problem 23RQ

(a)

Program Plan Intro

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);

(b)

Program Plan Intro

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);

(c)

Program Plan Intro

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);

(d)

Program Plan Intro

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 7, Problem 23RQ

(a)

Program Plan Intro

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);

(b)

Program Plan Intro

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);

(c)

Program Plan Intro

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);

(d)

Program Plan Intro

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 7, Problem 23RQ

(a)

Program Plan Intro

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);

(b)

Program Plan Intro

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);

(c)

Program Plan Intro

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);

(d)

Program Plan Intro

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 7, Problem 23RQ

(a)

Program Plan Intro

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 7, Problem 23RQ

(a)

Program Plan Intro

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

(b)

Program Plan Intro

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

(b)

Program Plan Intro

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

(c)

Program Plan Intro

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

(c)

Program Plan Intro

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

(d)

Program Plan Intro

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

(d)

Program Plan Intro

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. 7 - Prob. 1RQ Ch. 7 - Explain why the following command would create an...Ch. 7 - What is a cross join? Give an example of its...Ch. 7 - What three join types are included in the outer...Ch. 7 - Using tables named T1 and T2, write a query...Ch. 7 - Prob. 6RQ Ch. 7 - Rewrite the following WHERE clause without the use...Ch. 7 - Explain the difference between an ORDER BY clause...Ch. 7 - Explain why the following two commands produce...Ch. 7 - What is the difference between the COUNT aggregate...

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