Author Question: Suppose tables EMPLOYEE and CUSTOMER both store address information, and you want to send a letter ... (Read 40 times)

geoffrey · **on:** Jul 7, 2018

Suppose tables EMPLOYEE and CUSTOMER both store address information, and you want to send a letter to all employees and customers of your company to make a major announcement. Which SQL keyword would you most likely use here?

A) INTERSECT
B) UNION
C) UNION ALL
D) JOIN

Question 2

Explain the terms relation, tuple, and attribute.

What will be an ideal response?

hramirez205 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

B

Answer to Question 2

The terms relation, tuple, and attribute are used primarily by database theoreticians. These terms are synonymous with the terms table, row, and column, respectively, in regards to a relational database. They are also equivalent to the terms file, record, and field, which tend to be used by many traditional data processing professionals.