This topic contains a solution. Click here to go to the answer
« previous next »

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

geoffrey

  • Hero Member
  • *****
  • Posts: 880
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?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

hramirez205

  • Sr. Member
  • ****
  • Posts: 345
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.


geoffrey

  • Member
  • Posts: 880
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

matt95

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

The flow of information in a eukaryotic cell The flow of information in a eukaryotic cell
Head impact during sports may reduce ability to acquire new information Head impact during sports may reduce ability to acquire new information
The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen
A form letter is used when the same letter is sent to multiple recipients. A form letter is used when the same letter is sent to multiple recipients.
The medical assistant reviews the PDR for information related to a drug. The medical assistant reviews the PDR for information related to a drug.
Business Letter Format and Example. Business Letter Format and Example.
Video: Helper T cell receptors, activation, proliferation, differentiation & action

For a complete list of videos, visit our video library