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 50 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
Excellent

ryhom

  • Member
  • Posts: 366
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Apply compression and kneading to thigh muscles. Address the entire thigh: anterior, posterior, ... Apply compression and kneading to thigh muscles. Address the entire thigh: anterior, posterior, ...
The material safety data sheet (MSDS) for sulfuric acid showing the detailed technical information ... The material safety data sheet (MSDS) for sulfuric acid showing the detailed technical information ...
Management Information Systems: Managing the Digital Firm, 15th Edition Management Information Systems: Managing the Digital Firm, 15th Edition
Greek Letter psi Greek Letter psi
Simplified diagram of information flow (the central dogma) from DNA to RNA Simplified diagram of information flow (the central dogma) from DNA to RNA
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: Bulk flow - Factors that influence bulk flow

For a complete list of videos, visit our video library