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 30 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
:D TYSM

TheNamesImani

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Coding of Olfactory Information Coding of Olfactory Information
Example of a collection letter. Example of a collection letter.
Store vitamin B–rich whole-wheat flour in an airtight container in your refrigerator or freezer Store vitamin B–rich whole-wheat flour in an airtight container in your refrigerator or freezer
Consider the production function ( ) 0.5 0.5 Y = AK L . Suppose both saving rate (s) and the ... Consider the production function ( ) 0.5 0.5 Y = AK L . Suppose both saving rate (s) and the ...
The flow of genetic information The flow of genetic information
Suppose the market supply curve is p = 5Q. If price increases from 10 to 15, the change in ... Suppose the market supply curve is p = 5Q. If price increases from 10 to 15, the change in ...
Video: Optic Nerve and Optic Disk Animation (Part 1 of 2)

For a complete list of videos, visit our video library