The Tables Dept1 and Dept2 Are as Follows -A Relational Algebra Operator Applied to Tables Dept1 and Dept2

question 20

Multiple Choice

The tables Dept1 and Dept2 are as follows
$Table~Dept1\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

$Table~Dept2\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline 400 & \text { Sales } & \text { Reno } & 666 \\\hline\end{array}$
-A relational algebra operator applied to tables Dept1 and Dept2 produces the following result: $$\begin{array} { | l | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$$ The operation is:

• A) Dept1 UNION Dept2
• B) Dept1 INTERSECT Dept2
• C) Dept1 DIFFERENCE Dept2
• D) Dept2 DIFFERENCE Dept1

---

Definitions:

CDs

Compact Discs; a digital optical disc data storage format used for storing digital data, including music and software.

Household's Income

The total earnings received by all members of a household from various sources like wages, salaries, benefits, and investments, within a given period.

Budget Constraint

A limitation on the consumption choices of individuals or firms, dictated by their income and prices of goods.

Budget Constraint

A budget constraint represents the combinations of goods and services that a consumer can purchase given their income and the prices of those goods and services.