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 42 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

yeungji

  • Member
  • Posts: 319
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Hypertension is a silent killer because it is deadly and has no significant early symptoms. The danger from hypertension is the extra load on the heart, which can lead to hypertensive heart disease and kidney damage. This occurs without any major symptoms until the high blood pressure becomes extreme. Regular blood pressure checks are an important method of catching hypertension before it can kill you.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Healed bone fractures can provide clues about activities and fresh fractures can yield information a Healed bone fractures can provide clues about activities and fresh fractures can yield information a
In 2013, Americans learned that the federal government massively surveys their phone calls and e-mai In 2013, Americans learned that the federal government massively surveys their phone calls and e-mai
Examples of four letter formats: (A) block style, (B) modified block style, (C) modified block style ... Examples of four letter formats: (A) block style, (B) modified block style, (C) modified block style ...
Lean 6 sigma - Fishbone Diagram - CAUSES & Effects OF LOW CUSTOMER SATISFACTION Lean 6 sigma - Fishbone Diagram - CAUSES & Effects OF LOW CUSTOMER SATISFACTION
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 ...
The WISER entry for hydrogen cyanide (bottom). Useful information includes detailed health ... The WISER entry for hydrogen cyanide (bottom). Useful information includes detailed health ...
Video: Barriers - eye structures, digestive mucosa, respiratory mucosa & genitourinary mucosa

For a complete list of videos, visit our video library